Entering, Editing & Filling Data

Chapter 1 covered what a cell can hold and how to get to one. This chapter covers what happens once you're actually there — typing data in, changing your mind and editing it, and, most importantly, getting Excel to extend a pattern for you across dozens or thousands of cells instead of typing every single one by hand. That last skill, more than almost anything else in this course, is what separates someone who fights their spreadsheet from someone who lets it do the tedious part.

Editing a Cell You've Already Filled In

Once a cell has content, there are three ways to change it, and they behave slightly differently:

• Just start typing — this replaces the entire existing content the moment you press a key. Fastest option when the old value is wrong and you're replacing it completely.
• Press F2, or double-click the cell — this puts you into edit mode, cursor placed at the end of the existing content, so you can adjust just part of it rather than retyping everything.
• Click into the formula bar (the wide input field above the grid) — identical result to F2, just clicked into from a different location. Especially useful for long formulas, where editing inside the narrow cell itself is awkward.

While in edit mode, Esc cancels whatever you've changed and restores the cell's previous content — a genuinely useful undo-before-you-commit that many people don't realise exists until they've already fought with Ctrl+Z instead.

The Fill Handle: Excel's Most-Used Time-Saver

Select any cell (or range of cells) and look at the small solid square in the bottom-right corner of the selection — that's the fill handle. Click and drag it, and Excel extends whatever you selected into every cell you drag across. What it does with that extension depends entirely on what you originally selected:

Excel recognises weekday and month names, and simple numeric sequences, as built-in fill series — you're not limited to plain numbers and dates. You can even teach it your own sequence (File → Options → Advanced → Edit Custom Lists) if you regularly work with a fixed, repeating set of labels.

Flash Fill: Pattern Matching From Examples (Ctrl+E)

AutoFill extends a mathematical or calendar pattern. Flash Fill solves a different problem entirely: it looks at an example you type by hand next to your existing data, guesses the general rule behind it, and applies that rule to every other row.

A typical use: column A holds full names like "Grace Hopper." In column B, next to the first row, you type just "Grace" — the first name, typed out by hand as an example. Then either press Ctrl+E, or start typing the first name for row 2 and let Excel suggest the rest in grey preview text, then press Enter to accept it. Flash Fill infers "take the text before the first space" and applies that same rule down the rest of column B automatically.

Undo, Redo, and Deleting Content

A few habits are worth building early, since every later chapter assumes them:

• Ctrl+Z (Undo) and Ctrl+Y (Redo) — Excel keeps a genuinely deep undo history, not just one step back, so don't hesitate to experiment.
• Delete key — clears a selected cell's content entirely, without entering edit mode first.
• Backspace — if a cell is already selected (not in edit mode), Backspace also clears it; but once you're already inside edit mode (after F2 or double-click), Backspace instead deletes just the one character before your cursor, the way it would in any text field.

Hands-On Exercises