Editing · original practice scenario
Delete complete worksheet rows
Row 7 is an obsolete draft line in a disposable copy of a report.
Start here: Whole worksheet rows selected through their headers
Deletion changes the worksheet structure and may change formula references. Use Undo if the wrong header was selected.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Windows keys and context
Delete cells removes the selected structure, unlike the Delete key that clears cell contents. Select complete headers first.
Ctrl+-
Windows and Mac / Delete cells; whole-row or whole-column preselection. Microsoft reference ↗
Walk through the operation
- Click the row 7 header to select it completely.
- Use the listed deletion combination.
Instruction 1 of 2: Click the row 7 header to select it completely.
Expected result: The entire row is removed and the rows below move up.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
Related walkthroughs
- Abandon the current edit
- Select one character right while editing
- Select one character left while editing
- Insert complete worksheet rows
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.