If you mean a worksheet row, select the row where the new one should go and press Ctrl+Shift+Plus (+) in Excel for Microsoft 365 on Windows; Excel inserts a row above the selected row. To insert below a row, select the row immediately beneath the place you want the new one, then use the same shortcut.
The shortcut and what it does
The keyboard command inserts a whole worksheet row when an entire row is selected. On most Windows keyboards, the plus sign shares the key with the equals sign, so you press Ctrl+Shift+= to produce Ctrl+Shift+Plus. Some instructions write this as Ctrl++; they mean the same insert command. If your keyboard has a separate numeric keypad plus key, its behavior can depend on the keyboard and Excel setup, so the Ctrl+Shift+= combination is the dependable version to try first.
The direction is easy to misread: Excel inserts the new row above the selection. It does not insert below the selected row. For example, if row 8 is selected, the new blank row becomes row 8, and the old row 8 and everything below it move down. The contents of the selected row are not replaced; they shift down with the rest of the worksheet.
How to insert a row above
You can select a row by clicking its numbered heading at the left edge of the worksheet, or by selecting a cell in that row and using Shift+Space. Once the full row is highlighted, press Ctrl+Shift+=. These steps work whether the row contains data or is blank.
- Click a cell in the row where the new row should appear, such as A8.
- Press Shift+Space to select the entire worksheet row, or click its row number.
- Press Ctrl+Shift+=. If Excel asks what to insert, choose Entire row and confirm.
In most cases, selecting the full row first means Excel inserts it immediately without asking. The prompt is more likely when you select only one or more cells. It offers choices such as shifting cells down or inserting an entire row, because those actions affect different parts of the sheet.
How to insert a row below
Excel’s standard row-insertion shortcut places the new row above the selected row. To put a blank row below row 8, select row 9 and insert. The new row occupies position 9, pushing the previous row 9 and later rows down; the original row 8 remains directly above it. This select-the-next-row method is usually the quickest way to get the position you want.
Think of the selection as the insertion boundary’s lower edge: Excel makes space before the selected row. If row 9 already contains information, that information is preserved and moved to row 10. Check the row numbers and nearby labels after inserting if the sheet has a heading or a subtotal near the target area.
Adding several rows at once
You do not need to repeat the shortcut one row at a time. Select as many complete worksheet rows as you want to add, then press Ctrl+Shift+= once. Excel inserts the same number of new rows above the selection. For example, selecting rows 6 through 8 and inserting adds three blank rows above the selected block; the former row 6 and all following content move down three positions.
To add three rows below row 8, select rows 9 through 11 and insert. Make sure the selection includes the intended number of row headings, not merely three cells in one column. If you select cells rather than entire rows, Excel may show its Insert dialog and the outcome may be limited to those cells or columns.
Windows and Mac keyboard differences
On Excel for Microsoft 365 on Windows, use Ctrl+Shift+Plus (+), commonly typed as Ctrl+Shift+= on a standard keyboard. Shift+Space selects the current worksheet row. These are Excel shortcuts, not commands in the Windows menu system, so the exact key labels you see can vary with your keyboard layout.
In Excel for Mac, the insert-row shortcut is generally Control+Shift+=, while Shift+Space selects the row. Mac keyboards and layouts differ, and a keyboard setting or another app can intercept a combination. If the shortcut does not work, use the ribbon path Home > Insert > Insert Sheet Rows. The ribbon command is also a useful fallback on Windows. In Excel for the web, keyboard behavior can depend on the browser and its shortcuts; the Home ribbon’s Insert options are a straightforward alternative.
Ribbon and mouse alternatives
If you prefer not to use a keyboard combination, select a cell in the target row and open Home > Insert > Insert Sheet Rows. Excel inserts a complete worksheet row above the active selection. Another option is to right-click the selected row heading and choose Insert. These methods are helpful when you cannot remember the shortcut or need to confirm that you are inserting a sheet row rather than shifting only a few cells.
On Windows, the ribbon command can also be reached by pressing Alt, then H, then I, then R. Press the keys in sequence rather than holding all four together. Keyboard access keys can vary with Excel versions, language settings, or interface updates, so the visible ribbon path is the clearest fallback if that sequence differs on your computer.
Worksheet rows versus rows in an Excel table
A worksheet row runs across the entire sheet, from the first column to the last. The shortcut inserts that kind of row and shifts the worksheet content below it. An Excel table is a formatted, structured range inside the worksheet, and adding a row to the table is not always the same as inserting a sheet row. If your goal is to add a record to a table, use a cell in the table and choose the table-specific insert option, such as right-clicking a table row and selecting Insert > Table Rows Above. The wording may depend on the selected cell and version.
To add a new record at the bottom of a table, you can often press Tab from the last cell of the table’s last row; Excel extends the table with a new row. That is different from inserting a blank worksheet row above a selected row. Decide whether you want to expand the table’s structured data or create space in the worksheet around it. This distinction matters because formulas, table formatting, filters, and references can behave differently when the table itself changes.
Common problems and quick checks
- The shortcut opens an insert dialog. You may have selected a cell rather than a full row. Choose Entire row, or select the row heading first for a whole-row insertion.
- Excel inserts in the wrong place. Remember that the shortcut inserts above the selection. For an insertion below a row, select the next row down.
- The plus sign is hard to enter. On a typical keyboard, hold Ctrl and Shift, then press the equals key. On another layout, use the ribbon command if the key combination is inconvenient.
- The command seems to do nothing. Check that Excel, rather than another window, is active and that the worksheet is not protected against inserting rows. If the sheet is protected, the workbook’s protection settings may need to be changed by someone authorized to do so.
- You are at the bottom of the sheet. Excel worksheets have a fixed limit of 1,048,576 rows. You cannot insert another worksheet row if doing so would exceed that limit.
Also check whether the worksheet is filtered or grouped. A filter can hide rows, making the visible result look different from the row numbers you expect; grouped rows may be collapsed. Clear or review those conditions before inserting if the position is unclear.
Undoing an insertion and keeping the sheet organized
If you inserted a row by mistake, press Ctrl+Z on Windows or Command+Z on Mac to undo the action, provided you have not performed a later operation that changes the undo sequence. Undoing an insertion restores the previous layout. If the workbook is important, save it before making a batch of structural changes, especially when formulas, charts, or linked ranges depend on particular areas.
After inserting, inspect nearby formulas and formatting. Excel usually adjusts many ordinary cell references when rows are inserted, but complex workbooks can contain fixed ranges, external links, named ranges, or formulas that were designed around a particular layout. For a data list, insert within the intended list or table and verify that totals and filters still include the records you expect.
Frequently Asked Questions
What is the Excel shortcut to insert a row above?
On Windows, select the full row and press Ctrl+Shift+Plus (+), usually entered as Ctrl+Shift+=. Excel inserts a new worksheet row above the selection.
How do I insert a row below the selected row?
Select the row immediately below the desired position, then use the insert-row shortcut. Excel inserts above that selected row, which places the new row below the row you started from.
Can I insert multiple rows with one shortcut?
Yes. Select the same number of complete worksheet rows as the number you want to add, then press Ctrl+Shift+= on Windows. Excel inserts that many rows above the selected block.
What is the Mac shortcut to insert a row in Excel?
In Excel for Mac, try Control+Shift+= with the target row selected. If the keyboard layout prevents it, use Home > Insert > Insert Sheet Rows.
Why does Excel ask whether to shift cells or insert an entire row?
You likely selected cells instead of a full row. The dialog lets you choose between moving only those cells and inserting a complete worksheet row. Select the row heading if you want the whole row.
Related
- Excel Paste Numbers as Text? Keep IDs, Zeros, and Codes
- Excel Paste in Reverse Order: Practical Methods
- Excel Password Protect to Keep a Workbook from Opening?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Find the Highest Number in ExcelIf your numbers are in A2:A6, enter =MAX(A2:A6) in an empty cell to return the largest one. For…
- How to Hide Divide by Zero Errors in ExcelTo hide a divide-by-zero error in Excel, wrap the division in IFERROR, or use an IF test when…
- Import CSV into Excel on Mac: A Step-by-Step GuideTo import a CSV into Excel on a Mac, open Excel and choose Data > Get Data (Power…
- Excel Find and Replace Asterisk CharactersTo find a literal asterisk in Excel for Microsoft 365 on Windows, press Ctrl+H, enter ~* in Find…
- How to Change View Options in Outlook for a Better InboxTo change how your inbox looks in Outlook for Microsoft 365 on Windows, open the folder you want…
- How to Add a Running Header in Word for MacTo add a running header in Word for Mac, open the document, choose Insert > Header & Footer…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.