In Excel for Microsoft 365 on Windows, select a cell in the row where you want a new row, then press Ctrl+Shift++ (Ctrl, Shift, and the plus key). To insert several rows, select the same number of existing rows first; Excel adds the new rows above the selection.
The fastest way to insert a row
The shortcut depends on what is selected. If you select an entire row by clicking its number at the left edge of the worksheet, pressing Ctrl+Shift++ inserts a blank worksheet row above it. You can also select a cell in the target row and press Shift+Space to select that whole row, then use the insert shortcut.
On many keyboards, typing the plus sign requires holding Shift while pressing the equals key. That is why the shortcut may be written as Ctrl+Shift+= in some instructions. It means the same key combination as Ctrl+Shift+Plus. If your keyboard has a separate plus key on its numeric keypad, Ctrl plus that key may also work.
For example, to add a blank row above row 8, click a cell in row 8, press Shift+Space, and then press Ctrl+Shift++ on Windows. Excel moves the existing row 8 and the rows below it down, leaving the new blank row in the former row 8 position.
What the shortcut does
Excel interprets the insert command according to the selection. When a full worksheet row is selected, it inserts a complete row across the sheet. When you select a single cell or a smaller range instead, Excel may open the Insert dialog so you can choose whether to shift cells right, shift cells down, insert an entire row, or insert an entire column.
This distinction explains why the same shortcut can appear to behave differently for two people. Selecting a row header, or selecting a cell and using Shift+Space, makes the intended operation unambiguous. If the Insert dialog appears, choose Entire row and confirm. A row is inserted above the selected cell or range.
Inserting a row is different from clearing its contents. The command creates space in the worksheet and shifts existing cells below the insertion point downward. By contrast, pressing Delete or using Clear Contents removes values from cells but does not move the rows beneath them.
Insert one row or several rows
To insert a single row, select one row or a cell in the row that should move down. To insert multiple rows at once, select the same number of consecutive rows before using the shortcut. Excel places the new blank rows above the first row in the selection.
- Choose the row or rows that should move down.
- If selecting cells rather than row headers, press Shift+Space to select the current row. For a multirow insertion, select the required consecutive row headers.
- Press Ctrl+Shift++ on Windows.
- Check that the new blank rows appear above the selection and that the existing data has shifted down as expected.
For instance, selecting rows 8, 9, and 10 and inserting adds three blank rows above row 8. The former rows 8 through 10 move down, along with the data beneath them. This is usually quicker and more consistent than repeating the command three times, especially when the worksheet contains formatting or formulas tied to adjacent rows.
You can select several adjacent row headers by dragging down the row-number area, or by clicking the first row header and Shift-clicking the last. Make sure the highlighted selection covers the intended count. If you accidentally select four rows instead of three, the shortcut inserts four.
Select cells, rows, or columns correctly
The row-number area on the left is the clearest way to select a whole worksheet row. Clicking a row number highlights that row across the worksheet, not just the cells containing visible information. Then the insert shortcut inserts a full row. This is useful when the new row must keep the table-like layout aligned across multiple columns.
Shift+Space is handy when your hands are already on the keyboard. Click any cell in the target row and press Shift+Space; Excel selects the entire worksheet row. To select a whole column, use Ctrl+Space on Windows. With a full column selected, the insert shortcut inserts a column to its left. Check the selection before pressing the shortcut, since a mistaken full-column selection can rearrange more of the sheet than intended.
If only a cell range is selected, the Insert dialog lets you decide how to handle the surrounding cells. Inserting a row shifts cells down; inserting a column shifts cells right. Choosing the wrong option can break the alignment of data that belongs together, so use a full-row selection when the goal is to add a record line to an ordinary worksheet list.
Ribbon and context-menu alternatives
If you cannot remember the key combination, Excel provides commands on the ribbon. Select a cell in the target row, then choose Home > Insert > Insert Sheet Rows. The row is inserted above the active cell’s row. This is also a useful fallback when a keyboard layout, remote desktop, or browser intercepts the shortcut.
You can also right-click a row number and choose Insert. When a full row is selected, that command inserts a row above it. If you right-click a cell instead, the available command may open the Insert dialog, where you can choose the row option. The context menu can be convenient when you want to act with the mouse and verify the selected row at the same time.
The ribbon and context-menu commands perform the same basic worksheet operation as the keyboard shortcut. They do not add a special kind of row; they simply provide different ways to issue the insert command. This means the important decision remains the selection: select the appropriate row or rows before choosing any insertion method.
Excel for Mac and Excel for the web
On Excel for Mac, select the row or rows first. The insert-rows shortcut is generally Control+Shift+=, where the equals key produces the plus sign when Shift is held. Use the Control key rather than assuming Command will work; Office shortcuts on Mac do not always replace Ctrl with Command in the same way as common Mac application shortcuts. Keyboard layouts and Excel releases can affect the exact key sequence, so use the ribbon command if the shortcut does not respond.
On Mac, the ribbon alternative is Home > Insert and the sheet-row insertion command. You can also use the row-header context menu. These options are often easier than resolving differences between keyboard layouts, particularly on compact keyboards without a separate numeric keypad.
Excel for the web supports inserting rows from the ribbon and row-header context menu. Keyboard shortcuts may vary in practice because the browser or operating system can reserve certain combinations, and the web app may show shortcut guidance that differs by platform. If Ctrl+Shift++ does not work in a browser, select the row and use Home > Insert or right-click its row number. The result is still a worksheet row inserted above the selection.
Common shortcut problems
If nothing happens, first confirm that Excel has focus: click inside the workbook, then try again. A keyboard shortcut entered while the formula bar, a dialog, another application, or a browser control has focus may not reach the worksheet. Also check whether the sheet is protected; protection can prevent inserting rows unless the relevant permission is allowed.
- The Insert dialog opens: A cell or partial range is selected. Choose Entire row, or select the row header before repeating the shortcut.
- A column is inserted: A full column was selected. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the intended row.
- The shortcut types a character or does nothing: Try Ctrl+Shift+=, using the key that generates the plus sign on your keyboard, or use the ribbon command.
- The row cannot be inserted: Check for worksheet protection or whether the sheet has reached its row limit.
An Excel worksheet can contain up to 1,048,576 rows. If inserting a row would push nonempty cells beyond the bottom of the worksheet, Excel cannot preserve that content by shifting it down, so the insertion may be blocked. This is unusual in everyday lists but can matter in large imported datasets.
Effects on formulas, formatting, and tables
Excel generally adjusts references in formulas when rows are inserted. For example, formulas that refer to cells shifted by the insertion may be updated so they continue to refer to the intended data. However, formula behavior depends on the specific references and where the new row is inserted. After adding rows near totals, lookup ranges, or manually maintained calculations, inspect important formulas rather than assuming every range includes the new row automatically.
Formatting can also be carried into an inserted row from nearby cells. Excel may display an Insert Options button near the new row, allowing you to choose formatting behavior such as matching the row above or below, or clearing formatting. If the row looks different from its neighbors, use that option or copy the desired formatting from an adjacent row.
When working inside an Excel Table, inserting a worksheet row and adding a table record are related but not always identical actions. A table can expand as data is entered directly in the row below it, and table-specific commands may offer to insert a row within the table. If the goal is to add a record that belongs to the table, confirm that the new row is part of the table range; otherwise filters, structured references, and table formatting might not include it.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift++ (also written Ctrl+Shift+= on keyboards where plus is made with Shift and equals). On Mac, try Control+Shift+= after selecting the row.
How do I insert a row without using the mouse?
Click a cell in the target row, press Shift+Space to select the entire row, then press Ctrl+Shift++ on Windows. The selected row moves down and a blank row appears above it.
How do I insert multiple rows at once?
Select the same number of consecutive rows as the number you want to add, then use the insert shortcut. Excel inserts that many blank rows above the first selected row.
Does Excel insert the new row above or below?
It inserts above the selected row. Select the row that should move down; the blank row appears in its previous position.
Why does Excel show an Insert dialog instead?
You likely selected a cell or partial range rather than a complete row. Choose Entire row in the dialog, or press Shift+Space to select the full row before using the shortcut.