ShortcutdrillExcel shortcuts / editing / Delete a row and redo the total
Delete a row and redo the total in Excel: Shift+Space, Ctrl+-, Ctrl+Down, Down, Alt+= (Mac: Shift+Space, Control+-, Cmd+Down, Down, Option+=)
| Windows | Shift+Space, Ctrl+-, Ctrl+Down, Down, Alt+= |
|---|---|
| Mac | Shift+Space, Control+-, Cmd+Down, Down, Option+= |
| Group | editing |
Drill: Remove a row and total. Pro drill. Twenty-five drills are free.
What it does and when to use it
Remove a bad row, jump to the bottom, step into the total cell and AutoSum. A SUM over a fixed range would have shrunk with the deletion anyway, but a typed total would not; redoing it with AutoSum is the safe habit.
The common mistake
Leaving a typed total behind after deleting a row.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
Does deleting a row update my SUM?
Yes, if the row was inside the SUM range. The range shrinks by one row. A total typed as a number does not change.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill