The standard insert row keyboard shortcut in Excel is Ctrl + Shift + Plus (+) on Windows or Cmd + Shift + Plus (+) on Mac. The shortcut opens the Insert dialog or directly inserts a row depending on what is currently selected. When an entire row is selected before pressing the shortcut, Excel inserts a new row above the selection without showing the dialog.
When individual cells are selected rather than the whole row, the Insert dialog opens asking what to insert (rows, columns, cells with shift options). Understanding the selection state changes the shortcut behaviour produces faster row insertion workflows.
The fastest pattern combines two shortcuts. First, select the entire row using Shift + Space (Windows) or Shift + Space (Mac) — this selects the row containing your active cell. Second, press Ctrl + Shift + Plus to insert a new row above the selected row. Existing rows shift down by one position. The new empty row appears ready for input. The two-keystroke combination produces row insertion without leaving the keyboard or navigating through menus. Power users who insert rows frequently develop this pattern as automatic muscle memory.
For inserting multiple rows at once, select multiple rows first then use the insert shortcut. Select the first row by clicking the row number, then Shift+click another row number to select all rows in between, or hold Shift while pressing arrow keys to extend selection.
With multiple rows selected, Ctrl + Shift + Plus inserts the same number of new rows above the selection. Selecting 5 rows produces 5 new rows; selecting 10 rows produces 10 new rows. Bulk row insertion is substantially faster than inserting rows one at a time — particularly useful when adding many empty rows to a section before populating with new data.
The keyboard shortcut approach scales to extensive workbook editing. Users who maintain large Excel workbooks for inventory, financial reporting, or data analysis frequently need to insert rows for new entries. Doing this through mouse-based menu navigation accumulates substantial time across many operations daily. Mastering the keyboard shortcut combination produces meaningful productivity improvements over weeks and months of regular use.
Standard shortcut: Ctrl + Shift + Plus (Windows) or Cmd + Shift + Plus (Mac). Faster two-step: Shift+Space (select row) then Ctrl + Plus (insert). Multiple rows: Select multiple rows first; same shortcut inserts that many new rows. Alternative: Right-click row number → Insert. Ribbon path: Home tab → Insert → Insert Sheet Rows. Repeat last insert: F4 keyboard shortcut. Undo: Ctrl+Z reverses the insert. Position: New row always appears above the selected row.
Ctrl + Shift + Plus is the standard Excel insert shortcut across all object types — rows, columns, cells. The behaviour depends on selection state. When nothing specific is selected (just an active cell), the shortcut opens the Insert dialog asking what to insert. The dialog options: Shift cells right, Shift cells down, Entire row, Entire column. Click the appropriate option, press Enter. The dialog navigation adds keystrokes but provides flexibility for various scenarios.
When a row is already selected before pressing the shortcut, Excel inserts a new row immediately without showing the dialog. Excel knows you want a row inserted because a row is selected. This direct behaviour is faster than the dialog path — one keystroke combination versus dialog navigation. Similar behaviour applies for columns — select a column with Ctrl+Space, then Ctrl + Shift + Plus inserts a new column to the left. The matching shortcut pair handles both row and column insertion through the same keyboard combination.
The Shift key in Ctrl + Shift + Plus refers to the + symbol typically being a Shift-key character (= without Shift produces =, with Shift produces +). On some keyboards the + symbol is on its own key without needing Shift. International keyboards may have different key arrangements. The functional effect is the same — Ctrl + Plus or Ctrl + Shift + Plus both produce the insert action. If your keyboard does not respond to one form, try the other. The variations exist because of keyboard layout differences across regions.
The keyboard shortcut family in Excel follows consistent patterns across operations. Insert uses Ctrl + Shift + Plus; Delete uses Ctrl + Shift + Minus. Format Cells uses Ctrl + 1. Format painter uses Ctrl + Shift + C (copy format) and Ctrl + Shift + V (paste format). The pattern of Ctrl + Shift + key for related operations supports learning by building on patterns rather than memorising completely separate shortcuts. Excel's shortcut design is generally consistent even when specific shortcuts are arbitrary at first encounter.
Fastest method for keyboard-fluent users. Select row with Shift+Space first, then press Ctrl + Shift + Plus. New row inserts above selection. Works for single rows or multiple rows (selected before pressing shortcut). Combined with arrow key navigation, supports rapid row insertion without leaving keyboard. The most efficient method for users who insert rows frequently.
Right-click the row number (the row header on the left edge), select Insert from the context menu. New row inserts above the row you right-clicked. Works regardless of current selection because right-clicking the row number selects the row. Discoverable through intuitive context menu interaction. Familiar to most Excel users from general right-click experience.
Menu-based access. Home tab in the ribbon → Insert button (Cells group) → dropdown → Insert Sheet Rows. The dropdown also offers Insert Sheet Columns and Insert Cells options. Slower than keyboard shortcut or right-click but discoverable for users learning Excel. The ribbon path is the standard recommendation in many Excel tutorials.
Add the Insert Sheet Rows command to the Quick Access Toolbar (above the ribbon) for one-click row insertion without menu navigation. Right-click any ribbon command → Add to Quick Access Toolbar. The custom button is then always visible above the ribbon. Useful for users who prefer mouse-based workflows but want faster access than ribbon navigation. The setup takes 30 seconds for an ongoing time savings benefit.
Copy data, right-click target row, select Insert Copied Cells from context menu. Excel asks whether to shift existing cells down or right. This produces both a new row insertion and pastes the copied content into the new row in one operation. Different from regular Paste which overwrites existing content. Useful for moving data within a worksheet while preserving existing rows.
If your data is in an Excel Table (Ctrl+T), simply typing in the row below the table automatically extends the table to include the new row. The table's automatic expansion handles row addition without explicit insert operations. The behaviour produces seamless data entry without thinking about insert operations. Among the most useful features of Excel Tables for ongoing data entry.
The Shift + Space keyboard shortcut selects the entire row containing the active cell. The mechanic is essential for keyboard-based row insertion because Ctrl + Shift + Plus behaves differently with row selection versus cell selection. The two-shortcut combination of Shift + Space followed by Ctrl + Shift + Plus produces direct row insertion without dialog navigation. The pattern is among the most useful Excel keyboard combinations for users who work with row insertion frequently.
For multiple rows, several selection approaches work. Click the first row number, Shift+click the last row number — selects all rows in between. Click the first row number, Ctrl+click additional row numbers — selects non-contiguous individual rows (the insert behaviour with non-contiguous selection is more complex and sometimes produces unexpected results). Hold Shift while pressing arrow keys to extend a single-row selection in either direction. With multiple rows selected, the insert shortcut creates the same number of new rows as you had selected. Selecting 10 rows then inserting produces 10 new rows above the selection.
The relationship between selection and insert position matters for predictable results. Excel always inserts new rows above the topmost selected row. To insert rows below specific content, select the row that should remain in place below the inserted rows.
For example, to add 5 empty rows between rows 10 and 11 of your data, select rows 11-15 and insert — Excel creates new empty rows above row 11, effectively making rows 11-15 become 16-20 with empty rows 11-15. Practising this pattern produces predictable insertion behaviour. Like understanding how Absolute Reference Excel behaviour affects formulas during structural changes, understanding selection-and-insertion positioning prevents surprise effects.
Active cell behaviour during selection matters subtly. When you select a row with Shift + Space, the active cell (which had the focus before selection) remains the active cell within the selection. Subsequent operations sometimes operate on the active cell specifically rather than the entire selection. The distinction rarely matters for insert operations but affects some other shortcuts. Understanding active cell versus full selection produces predictable behaviour across various keyboard operations.
Ctrl + Shift + Plus (using the Plus key, with or without explicit Shift depending on keyboard). Works the same in Excel 2016, 2019, 2021, and 365. The shortcut has been stable across many Excel versions making it reliable for users who upgrade Excel over time. Some Windows keyboard layouts have the + key requiring Shift; others have a dedicated + key. The functional behaviour is identical regardless of the specific key arrangement.
Cmd + Shift + Plus or Cmd + Shift + = (the = key with Shift produces +). Cmd key replaces Ctrl on Mac. Most Mac keyboard layouts work with Cmd + Shift + = which is the same key combination as = with Shift. Some Mac users find the shortcut feels different from Windows because Cmd location differs from Ctrl location on Windows keyboards. Adjustment period exists when moving between platforms.
The browser-based Excel has many shortcuts that match desktop Excel including most insert shortcuts. Ctrl + Shift + + works in Excel Online for inserting rows when a row is selected. Some shortcuts require browser-specific modifier keys. Microsoft documentation on Excel for the web lists current browser-supported shortcuts. The shortcuts have improved substantially over time as Excel Online has matured.
iPad and mobile Excel have different interaction patterns. With external keyboards connected, the standard Cmd + Shift + + shortcut works on iPad. Without keyboard, touch-based interaction through context menus is the primary path — tap the row number to select, tap Insert from the action menu. The mobile experience prioritises touch over keyboard shortcuts but supports both. Mobile usage primarily for viewing and light editing rather than heavy structural manipulation.
VBA can insert rows programmatically using Range or Rows object methods. Rows("5:5").Insert inserts a new row 5 (existing row 5 becomes row 6). Programmatic insertion bypasses the keyboard shortcuts but produces the same end result. Useful for automation of repetitive row insertion tasks across many worksheets or workbooks. Combined with loops, VBA can insert many rows based on data conditions or other logic.
Power Query (Get & Transform Data) handles row-level transformations differently from cell-by-cell editing. Filter rows, add custom rows through formulas, sort and rearrange rows through Power Query transformations. The approach is more appropriate for bulk row operations during data preparation than for manual row insertion during workbook editing. Different use cases for different tools.
Excel inserts the same number of rows as you have selected. The multi-row insert is substantially faster than inserting rows one at a time when you need many new rows. Selecting 10 rows before pressing Ctrl + Shift + Plus produces 10 new empty rows in one operation. Selecting 50 rows produces 50 new empty rows. The bulk approach handles preparation of empty space for upcoming data entry or for inserting space between data sections.
Selection methods for multi-row selection: click the first row number, Shift+click the last row number — selects all rows in between (contiguous selection). Click the first row number, hold Shift and press arrow keys — extends selection one row at a time. For non-contiguous selection (multiple separate row groups), Ctrl+click additional row numbers — but insert behaviour with non-contiguous selection is less predictable than contiguous selection, often producing unexpected results. Contiguous selection followed by insert is the reliable pattern.
Practical use cases for bulk row insertion include preparing templates for upcoming data, restructuring existing data to add categories or subtotals, separating data sections with empty rows for readability, and creating space for inserting external data via paste operations. Workbooks like Budget Template Excel often need bulk row additions when expanding budget categories or adding new accounts. The bulk insert capability scales well — even hundreds of rows can be inserted in seconds rather than minutes of one-at-a-time clicking.
Verification matters after bulk row insertion. Inserting many rows at once produces substantial structural changes that may affect formulas, named ranges, or other workbook elements. Quick visual review after insertion checks that the result matches intent — correct number of rows, correct positioning, no obvious formula breakage. Save the workbook before substantial structural changes; if results are unexpected, Ctrl+Z or reverting to saved state recovers the previous structure efficiently.
The F4 keyboard shortcut repeats the last action in Excel. After inserting a row, pressing F4 inserts another row at the current selection. The shortcut chains repeated operations efficiently. Workflow: select row, insert (Ctrl + Shift + Plus), navigate to next location, press F4 to insert another row at that location. The F4 repeat works for many Excel operations beyond insert — format changes, copy operations, value entries. For users who insert rows at multiple locations across a worksheet, F4 saves substantial keystrokes compared to retyping the insert shortcut each time.
F4 has different behaviour during formula editing — it cycles through reference types (relative, absolute, mixed) for the reference under the cursor. During cell editing or formula entry, F4 changes references rather than repeating actions. The dual function of F4 depends on context: outside formula editing, F4 repeats the last action; inside formula editing, F4 toggles reference types. The context-sensitive behaviour is helpful once understood but sometimes confuses users encountering F4 in different states.
The F4 repeat function works for many Excel operations beyond row insertion. Copy a cell, then F4 pastes again. Format a cell yellow, then F4 applies yellow to next selected cell. Delete a row, then F4 deletes the current row. The general repeat-last-action capability makes F4 one of Excel's most useful keyboard shortcuts. Building muscle memory for F4 produces broad productivity benefits across many editing tasks beyond just inserts.
Excel for Mac uses Cmd instead of Ctrl as the primary modifier key. The insert row shortcut is Cmd + Shift + Plus or Cmd + Shift + = on Mac. The functional behaviour matches Windows — select row first, press shortcut, new row inserts above. Mac users transitioning from Windows sometimes find the Cmd key location differs from where Ctrl is on Windows keyboards, producing initial friction. After adjustment, Mac shortcut performance matches Windows.
Mac-specific considerations include keyboard layout variations. Different Mac keyboards (Apple Magic Keyboard, MacBook built-in, third-party keyboards) have slightly different key positions and modifier behaviour. The + key may be a dedicated key or may require Shift on the = key depending on the specific keyboard. Functional shortcuts handle either case — Cmd + Shift + + and Cmd + Shift + = produce the same insert behaviour in Excel for Mac. Some Mac users also use trackpad gestures or Touch Bar shortcuts for additional efficiency, but keyboard shortcuts remain the primary path.
Touch Bar Mac users can configure Touch Bar shortcuts for frequently used operations including row insertion. The configuration adds a one-tap option without using keyboard shortcuts. Trackpad gestures combined with keyboard modifiers also support efficient editing on Mac. Mac users who work heavily in Excel often develop personal shortcut configurations that leverage Mac-specific interaction capabilities alongside the standard keyboard shortcuts that match Windows behaviour.
The most common reason Ctrl + Shift + Plus does not produce row insertion is selection state. If you have selected individual cells rather than an entire row, Excel opens the Insert dialog asking what to insert instead of immediately inserting a row. The dialog requires additional steps (selecting Entire Row option, clicking OK or pressing Enter) before the insertion completes. To produce immediate row insertion, ensure the entire row is selected before pressing the shortcut — use Shift+Space first to select the row.
Keyboard layout differences can affect shortcut behaviour. International keyboards may have the + key in different positions or require different modifier combinations. If Ctrl + Shift + + does not work on your keyboard, try Ctrl + Plus without Shift, or try the action through Excel's menu access to verify the action itself works. Once you have confirmed the action works through menus, you can investigate why the specific shortcut combination is not registering. Windows keyboard layout settings (Settings → Time & Language → Language) sometimes affect special character interpretation.
Conflicting software occasionally intercepts shortcuts before they reach Excel. Some screen capture tools, system utilities, or accessibility software bind Ctrl + Shift + + or similar combinations to their own functions. Temporarily disabling background utilities helps identify whether shortcut interception is the issue. The Windows keyboard shortcut for inserting rows is documented in Excel's help system; verifying the documented behaviour matches what you experience helps diagnose any deviation.
After selecting a row with Shift+Space, Ctrl + Minus deletes the row. The opposite of insert. Existing rows below shift up to fill the deleted position. Like insert, the shortcut works for single rows or multiple selected rows. Combined with insert shortcuts, gives full keyboard control over row structure changes.
Selects the entire row containing the active cell. Essential prerequisite for keyboard-based row operations. Pairs with Ctrl + Shift + Plus for insert, Ctrl + Minus for delete, and various other row-level operations. The keyboard alternative to clicking the row number on the left edge.
Selects the entire column containing the active cell. The column equivalent of Shift + Space for rows. Pairs with insert and delete shortcuts for column operations. The keyboard alternative to clicking the column letter at the top.
When a row or column is already selected, Ctrl + Plus inserts without the Shift modifier needed. The shortcut variant works because Excel recognises the selection state and skips the dialog. Some users find Ctrl + Plus more comfortable than Ctrl + Shift + Plus for repeat operations. Both shortcuts produce the same result with selected rows.
Selects the entire worksheet or table. Useful for whole-worksheet operations. Pressing Ctrl + A twice selects the entire worksheet beyond just the current data region. Combined with formatting or other operations, supports bulk changes across the entire worksheet.
Reverses the last action. Essential for recovering from accidental row inserts or other mistakes. Excel maintains up to 100 actions in undo history (varies by version and configuration). Combined with Ctrl + Y (redo), supports exploration of changes with easy reversal. The safety net for all Excel editing operations.
Keyboard shortcuts produce substantial time savings for repetitive operations. Studies of expert spreadsheet users consistently show they accomplish more in less time partly because of keyboard fluency. The Ctrl + Shift + Plus shortcut might save only a second or two per row insertion, but across hundreds or thousands of insertions over a career, the cumulative time savings is substantial. Beyond raw time, keyboard shortcuts reduce cognitive load — your hands stay on the keyboard and your eyes stay on the data rather than tracking the mouse cursor and ribbon menus.
The learning curve for shortcuts requires investment but pays back consistently. Each shortcut you memorise needs perhaps 5-10 conscious uses before becoming automatic muscle memory. After that, the shortcut produces speed and efficiency without conscious thought. Building shortcut vocabulary gradually — adding one or two new shortcuts per week — produces strong shortcut command over months rather than days. The Insert row shortcuts (Ctrl + Shift + Plus, Shift + Space, Ctrl + Minus) are among the highest-value shortcuts to learn early because row operations are so common in typical Excel work.
Ctrl + Shift + Plus on Windows or Cmd + Shift + Plus on Mac. When a row is selected first (use Shift + Space to select the row), the shortcut directly inserts a new row above the selected row. When cells are selected rather than a row, the shortcut opens the Insert dialog asking what to insert. The faster pattern: Shift + Space to select the row, then Ctrl + Shift + Plus to insert.
Select multiple rows first, then use the insert shortcut. Click the first row number, Shift+click the last row number to select all rows in between. With multiple rows selected, press Ctrl + Shift + Plus. Excel inserts the same number of new rows as you had selected. Selecting 5 rows produces 5 new rows; selecting 10 rows produces 10 new rows. Bulk insertion is substantially faster than inserting rows one at a time.
Most common cause: a row is not selected when you press the shortcut. Excel opens the Insert dialog instead of immediately inserting because individual cells are selected rather than a full row. Use Shift + Space first to select the row, then press Ctrl + Shift + Plus. Other causes: international keyboard layout differences (try Ctrl + Plus without Shift), conflicting software intercepting the shortcut, Windows keyboard layout settings affecting special character interpretation.
No directly. Excel always inserts above the topmost selected row. To insert below a specific row, select the row that should remain immediately after the inserted rows. For example, to insert 3 empty rows between rows 5 and 6, select rows 6-8 and insert — Excel adds 3 empty rows above row 6. The positioning rule is consistent: select the row that should be below the new rows, then insert.
Select the row first with Shift + Space, then press Ctrl + Minus to delete. The row is removed and existing rows below shift up to fill the position. Multiple rows can be deleted at once by selecting multiple rows first before pressing the shortcut. Ctrl + Minus is the symmetric opposite of Ctrl + Plus for insert — selecting and acting on rows works through the same paired keyboard pattern.
Functionally similar in most cases. Ctrl + Plus works when a row or column is already selected — Excel recognises the selection state and inserts without dialog. Ctrl + Shift + Plus also works in selected-row state. When individual cells are selected rather than rows or columns, both shortcuts open the Insert dialog. The Shift modifier provides equivalent action — choose whichever combination feels more comfortable. International keyboards may favour one combination over the other based on key layouts.