Editing and filling practice exercises

Edit a cell without retyping it, fill a formula down a column, add a total in one keystroke and undo your way out of mistakes.

Start the first exercise

How to edit and fill cells with shortcuts

F2 opens the cell you're in for editing, so you can fix a typo without retyping. Esc backs out and keeps the old content, Enter confirms and moves down, and Tab confirms and moves right. Ctrl+D copies the top cell of a selection down, Ctrl+R copies the leftmost cell to the right, and Alt+= adds a SUM total. Ctrl+Z undoes and Ctrl+Y redoes.

Say C2 holds =B2*0.25. Select C2:C20 and press Ctrl+D, and the formula fills every row, and the references adjust as it goes. If the formula points to a rate in F1, press F4 while the cursor is on F1 to turn it into $F$1, so it stays put when you fill: =B2*$F$1.

F4 only cycles through $F$1, F$1 and $F1 while you are editing a formula, and on some laptops you need to hold Fn. To fill a whole selection at once, type the formula and press Ctrl+Enter instead of Enter. The exercises below cover F2 and Esc, filling down and right, AutoSum with undo and redo, locking a reference with F4 and Ctrl+Enter.

  1. 1Edit a cell without retyping itOpen a cell for editing, back out of it, and move on with Enter and Tab.
  2. 2Fill a formula down and rightCopy a formula to the rows below and the column next to it without retyping it.
  3. 3AutoSum, undo and redoAdd a total with one shortcut, then undo and redo it.
  4. 4Lock a reference with F4Fix a formula so it can be filled down, without retyping it.
  5. 5Fill every selected cell with Ctrl+EnterPut one formula into a whole selection at once.

Read the guide

Questions

How do I fill a formula down to the last row without dragging?

Double-click the fill handle, the small square in the bottom-right corner of the cell. Excel fills down as far as the column next to it has data. You can also click the formula cell, hold Shift and click the last row you need, then press Ctrl+D. The second way works even when the neighboring column has gaps.

What is the AutoSum shortcut in Excel?

Press Alt+= in the cell below or to the right of your numbers. Excel types a SUM formula and guesses the range, so check the highlighted cells before you press Enter. Select several cells first and one press adds a total under every column in the selection. Alt+= works the same for a row of numbers.

How do I undo more than one step in Excel?

Press Ctrl+Z once for each step you want to undo. To go back several steps in one go, click the small arrow next to the Undo button at the top of the window and pick the step in the list. Everything above it is undone too. Ctrl+Y redoes the steps you undid, as long as you haven't made a new change.