Building a sheet is mostly editing: copying a formula down a column, adding a row you forgot, moving a block of data. Knowing a handful of keys makes this quick and gives you a safety net for mistakes.
Filling formulas and series
To copy one formula over many cells, select the formula cell together with the cells you want to fill, then press Ctrl + D to fill down or Ctrl + R to fill right. The fill handle, the small square at the corner of the selection, does the same by dragging. Double-clicking it fills down as far as the data in the next column goes.
Fill also continues patterns. Type 1 and 2 in two cells, select both and drag the handle, and Excel carries on with 3, 4, 5. Days of the week and month names work the same way. After filling, a small options button appears, where you can switch to copying the values only or copying the formatting only.
Inserting and deleting
To add a row, select a cell or a row number and press Ctrl + Shift + +. Existing rows move down to make room. To remove a row, press Ctrl + -. Columns work the same way.
Formulas adjust themselves. If a total is =SUM(B2:B5) and you insert a row between rows 3 and 4, the formula becomes =SUM(B2:B6), so the new row is counted. A row added below the last row of a range is outside it, so check the total when you add data at the bottom.
Deleting a row or column that a formula depends on is different. The formula shows a #REF! error because its data no longer exists.
Moving data
Cutting and pasting, or dragging the border of a selection, moves cells. A moved formula keeps its references exactly as they were, even though it now sits somewhere else, and any formula that pointed at the old place follows the data to the new one. Copying behaves differently: relative references shift to fit the new position.
This matters when you rearrange a finished sheet. Moving a total is safe. Copying it somewhere else may make it point at the wrong cells.
Undo is your safety net
The Undo button and its keyboard shortcut reverse your last action, and using them again goes back further. Redo brings back what you undid. The small arrow beside Undo lists recent steps, so you can reverse several at once. Excel keeps up to 100 steps by default, and closing the file clears that history. Some actions, such as running a macro, cannot be undone.
A good habit is to undo at the first sign that a paste or fill did something unexpected. Fixing it right away is much easier than untangling it later.