Getting text and numbers into a cell, and correcting them without a fuss, is the single most useful skill in Excel. By the end of this page you will know how to type into a cell, how to edit what is already there, and how to undo a mistake in a heartbeat.
Click on any cell and start typing. Whatever you type appears in the cell and also in the long white bar above the grid, called the formula bar. When you press Enter, Excel accepts what you typed and moves you down one cell. Press Tab instead and it moves you one cell to the right. That is really all there is to entering information.
- Shows the full text as you type
- The cell being edited
If a cell already has something in it and you simply start typing, Excel replaces the whole contents with your new entry. That is fine when you want a clean swap. But if you only want to fix a typo or add a word in the middle, you need to get inside the cell instead of overwriting it. You do this by double-clicking the cell, or by clicking it once and pressing the F2 key on your keyboard. Either way, you will see a blinking cursor appear inside the text, and you can use the arrow keys to move around and edit exactly as you would in a word processor.
Try it yourself
Click an empty cell and type your first name, then press Enter.
This shows the basic rhythm: click, type, Enter to confirm and move on.
Click back on that cell once, then press F2.
F2 puts you into editing mode inside the cell without deleting what is already there.
Use the Left and Right arrow keys to move the cursor, and add a middle initial.
This is exactly like editing a sentence in a word processor, just inside a small box.
Press Escape instead of Enter partway through an edit.
Escape cancels the edit and puts the cell back to how it was, which is a safe way out if you change your mind.
Select the cell and press the Delete key, then press Ctrl+Z.
Delete clears the contents; Ctrl+Z (undo) brings them straight back, which is worth knowing before you need it in a panic.
Words people use
Once typing, editing and undoing feel automatic, everything else in Excel becomes far less stressful, because you know that almost nothing you do is permanent or unfixable. Ctrl+Z is your safety net, and it is worth reaching for on instinct rather than trying to manually reverse a mistake.
Check yourself
If you can say yes to each of these, you are ready for the next lesson.
- I can type into a cell and confirm it with Enter or Tab.
- I can open a cell for editing with a double-click or F2 without erasing it.
- I know the difference between Delete and Backspace when editing inside a cell.
- I can undo a mistake straight away with Ctrl+Z.