Editing · original practice scenario
Insert complete worksheet rows
You need a blank row above the item currently in row 6.
Start here: Whole worksheet rows selected through their headers
Selecting only a few cells can open an insertion dialog or shift only those cells. Work on a copy when changing a real report.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Mac keys and context
This combines whole-row or whole-column selection with the documented Insert cells command. On a US Windows keyboard, the plus key also requires Shift.
Ctrl+Shift+=
Windows / Insert cells; Mac / Insert cells; whole-row or whole-column preselection. Microsoft reference ↗
Walk through the operation
- Click the row 6 header to select it completely.
- Use the listed insertion combination.
Instruction 1 of 2: Click the row 6 header to select it completely.
Expected result: A blank worksheet row appears above the old row 6.
Recall the keys
Which listed Mac 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 columns
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.