Excel Insert Shortcut: Add Cells, Rows, and Columns

In Excel for Microsoft 365 on Windows, select the cells, row, or column where you want space, then press Ctrl+Shift++ (Ctrl and Shift with the plus key) to open the Insert dialog or insert the selected row or column. For a cell selection, choose whether to shift existing cells down or right; for a whole row or column selection, Excel inserts it directly.

What the Excel insert shortcut does

“Insert” can mean several different things in a spreadsheet: adding blank cells, adding a worksheet row or column, creating a new sheet, or adding an object such as a table. There is no single shortcut for every kind of insertion. The most common keyboard shortcut people mean is Ctrl+Shift++, which inserts cells, rows, or columns according to what is selected.

On many Windows keyboards, the plus sign shares the equals key. In that case, press Ctrl+Shift+=; the Shift key produces the plus sign. If your keyboard has a separate numeric keypad plus key, Ctrl with that plus key may also work. The key label and keyboard layout can affect which combination is easiest to press.

The selection determines the result. With one or more ordinary cells selected, Excel displays an Insert dialog because it needs to know where existing cells should move. Select complete worksheet rows or columns first, and Excel can insert the same number of rows or columns without asking that question.

Insert cells, rows, or columns step by step

Use this sequence when you need to create space without overwriting existing data:

Select the cell or range where the new space should begin. Excel inserts cells above and to the left of the selection.
Press Ctrl+Shift++. If your keyboard uses the equals key for plus, press Ctrl+Shift+=.
If the Insert dialog appears, choose Shift cells right or Shift cells down, then select OK.

For example, selecting B4 and choosing Shift cells down adds a blank cell at B4 and moves the previous contents of B4 and the cells below it down by one. Choosing Shift cells right moves the contents of B4 and the cells to its right one position right. These options move cells, not entire worksheet rows or columns, so use them carefully when neighboring columns contain related records.

To insert a whole row, select its row heading first. For instance, select row 4 by clicking the number 4 at the left edge of the sheet, then press the shortcut. The new row appears above row 4. To insert several rows at once, select the same number of row headings as the number of rows you need; selecting rows 4 and 5 and inserting adds two rows above row 4. The same principle applies to columns: select their letter headings, then use the shortcut to insert columns to the left.

Shortcuts for other common insert actions

When the goal is not blank cells, use the shortcut or command for that specific item instead. These are useful distinctions:

New worksheet: Press Shift+F11 on Windows. Excel adds a worksheet to the workbook. On some Mac keyboards, function-key settings mean you may need Fn+Shift+F11; the plus button beside the sheet tabs is another option.
Excel table: Select a cell in the data range and press Ctrl+T on Windows, then confirm the range and whether the data has headers. A table adds structured formatting and filtering; it does not insert blank cells into the grid.
Ribbon command for rows: Use Home > Insert > Insert Sheet Rows. This inserts worksheet rows above the selected row or rows.
Ribbon command for columns: Use Home > Insert > Insert Sheet Columns. This inserts worksheet columns to the left of the selected column or columns.
Ribbon command for cells: Use Home > Insert > Insert Cells to open the insert choices for a cell selection.

These commands help prevent a common mistake: pressing the cell-insertion shortcut while expecting a table or a new worksheet. Excel treats those as different operations.

How to choose between cells and full rows

Insert a full row when a new record needs space across the worksheet. For example, if a sales list uses columns A through G, inserting a worksheet row keeps the new position aligned across all seven columns and any other used columns on that row. Inserting only a cell in column A could shift names without shifting the matching sales figures in column B, making the records incorrect.

Insert individual cells when the layout is intentionally uneven, such as a small schedule or a form with merged headings and separate blocks of information. Before choosing Shift cells down or Shift cells right, inspect nearby data: shifting one area can break the alignment between labels and values elsewhere in the same rows or columns.

For a block of new space, select a range before inserting. Excel moves the existing cells according to the choice in the dialog. If the range is part of a formatted Excel table, table-specific behavior may apply, and inserting worksheet cells through the grid can be restricted. In that case, use the table’s row-insertion options or add a row at the bottom of the table and expand it as needed.

What happens to formulas and formatting

When you insert a worksheet row or column, Excel generally adjusts references in formulas that refer to cells moved by the insertion. For example, a formula that refers to a cell below a newly inserted row will commonly be updated to keep referring to the original data. However, do not assume that every formula or external link will behave as intended: references written as text, links to other workbooks, and complex ranges can need review.

Inserted cells often inherit formatting from nearby cells. Depending on the insertion route, Excel may show an Insert Options button that lets you choose how formatting is applied, such as matching the formatting above or below. This matters in sheets with borders, number formats, or alternating colors. Check formulas, totals, and visual formatting after a structural change, especially in a workbook used for reporting.

Common shortcut problems and fixes

The shortcut types a plus sign instead: Check that Ctrl is held down and, on a keyboard where plus shares the equals key, include Shift. You can also use the ribbon command rather than relying on the physical key layout.
Excel opens a dialog rather than inserting a row: You probably selected cells rather than the row heading. Press Esc if needed, select the row number at the left of the sheet, then repeat the shortcut.
The new row appears in the wrong place: Excel inserts above the selected row; columns are inserted to the left of the selected column. Select the heading immediately below or to the right of the intended location.
The shortcut seems unavailable: Another application, a browser, or a customized keyboard layout may intercept the keys. Try the Home tab’s Insert menu, or right-click a row or column heading and choose Insert.
Data no longer lines up: A single-cell insertion may have shifted only part of a record. Undo immediately with Ctrl+Z if the change is still the last action, then insert an entire row or column instead.

Undo is helpful for a simple insertion, but verify the sheet after using it: later changes may mean Ctrl+Z reverses more than the insertion you intended. Saving a copy before major structural edits is a sensible precaution for important workbooks.

Windows, Mac, and Excel for the web

The instructions above use Excel for Microsoft 365 on Windows. In Excel for Mac, the insert-cells combination is generally Control+Shift+= on common keyboard layouts, rather than substituting Command for Control. Keyboard layouts and function-key settings differ, so if the key combination does not work, use the Mac ribbon’s Insert commands or the context menu. The shortcut for a new worksheet may also require the Fn key, depending on the keyboard’s function-key setting.

Excel for the web shares many familiar commands, but browser shortcuts or the particular keyboard can affect key combinations. If the insert shortcut is intercepted or unclear, select the row or column and use the Insert options on the ribbon. The key principle is the same across editions: select a cell for an insert dialog, or select full row or column headings to add whole worksheet rows or columns.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
Select the row heading, then press Ctrl+Shift++ on Windows. If plus shares the equals key, use Ctrl+Shift+=. Excel inserts the new row above the selected row.

What is the shortcut to insert a column in Excel?
Select the column heading, then use the same Windows insert shortcut, Ctrl+Shift++. The new column appears to the left of the selected column.

How do I insert cells without adding a whole row?
Select the cell or range and press Ctrl+Shift++. In the Insert dialog, choose whether to shift existing cells down or right. Check nearby data first so related values remain aligned.

How do I insert a new sheet in Excel?
Press Shift+F11 in Excel for Windows. You can also select the plus button beside the worksheet tabs. On some Mac keyboards, use Fn with Shift+F11 or choose the sheet-insertion command from the menus.

Why does Excel ask whether to shift cells down or right?
Excel asks because you selected cells rather than complete row or column headings. It needs to know how the existing cells should move to make room. Select a full row or column first if you want to insert one across the worksheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.