Insert Rows and Columns in Excel: Shortcuts & Steps

In Excel for Microsoft 365 on Windows, select a row with Shift+Space or a column with Ctrl+Space, then press Ctrl+Shift+= to insert. Excel places a new row above the selected row or a new column to the left of the selected column.

The fastest keyboard shortcuts

The insert shortcut is often described as Ctrl++ or Ctrl+Plus. On a standard US keyboard, the plus sign shares the equals key, so you press Ctrl+Shift+=. If your keyboard has a numeric keypad, Ctrl plus the keypad’s plus key may also work. The exact key combination can vary with keyboard layout, but the action is the same: select what you want to insert around, then invoke Insert.

For one complete row or column, use this sequence:

Click a cell in the row or column where the new space should appear.
Press Shift+Space to select its entire worksheet row, or Ctrl+Space to select its entire worksheet column.
Press Ctrl+Shift+=.

For example, if you want a blank row between rows 8 and 9, select any cell in row 9, press Shift+Space, and then use the insert shortcut. Excel adds a blank row above row 9, moving the previous row 9 and everything below it down. To add a column between columns B and C, select a cell in column C, press Ctrl+Space, and insert; the new column appears to the left of C.

Why row and column selection matters

The insert command behaves differently depending on what is selected. Selecting an entire row or column tells Excel to insert a complete worksheet row or column. If you select only a cell or a small group of cells and press the shortcut, Excel opens the Insert dialog instead. That dialog asks whether to shift selected cells right, shift them down, or insert entire rows or columns.

This distinction helps prevent accidental changes to the shape of a worksheet. Suppose a report has dates in column A and matching sales figures across columns B through D. Inserting a full worksheet column keeps the rows aligned while moving the existing data to the right. Inserting only a few cells can leave neighboring data in place, which may be useful for a local adjustment but can misalign a table if that was not intended.

Excel also inserts in relation to the selection: a selected row is followed by a new row above it, and a selected column is followed by a new column to its left. The shortcut does not add the row below or the column to the right. To put space after a particular row, select the next row first; to put space after a column, select the next column.

Insert from the Excel ribbon

If you prefer menus or cannot remember the key combination, use the Home tab. Select a cell in the destination row or column, then choose Home > Insert > Insert Sheet Rows or Home > Insert > Insert Sheet Columns. These commands insert a full worksheet row or column above or to the left of the active selection.

You can also select the row or column heading before using the ribbon. Row headings are the numbered labels along the left edge of the grid; column headings are the lettered labels along the top. After selecting a heading, choose Home > Insert. The Insert menu adapts to the selection and offers an appropriate row or column command. This is a useful method when working with a touchpad, a compact keyboard, or a keyboard layout where the plus key is awkward to reach.

In some Excel windows, the Insert button has a dropdown arrow. Use the arrow to see the available commands rather than clicking the main button without checking what is selected. Excel also provides a right-click menu for row and column headings; choose Insert there to add a full row or column. The ribbon and context menu are good alternatives when keyboard focus is in a cell editor, a search box, or another part of the interface and a shortcut does not act on the worksheet as expected.

Insert several rows or columns at once

To insert more than one row in a single operation, select the same number of existing rows as the number of blank rows you want. For example, to add three rows above row 10, select rows 10 through 12 by dragging across their row headings or by selecting a cell in row 10 and extending the row selection. Then use Ctrl+Shift+= or the ribbon command. Excel inserts three blank rows above the first selected row. The existing rows 10 through 12 move down.

The same principle applies to columns. Select two column headings to add two columns, or select cells in the intended columns and use Ctrl+Space to select the column for each selection as appropriate. For a simple contiguous block, dragging across the column headings is often the clearest approach. Check the highlighted selection before inserting: Excel uses the number of selected complete rows or columns to determine how many to add.

This technique is more predictable than repeating the shortcut several times. Repeating the command may work, but each insertion changes the positions of the content underneath, making it easier to lose track of the target. Selecting the required number of rows or columns first makes the quantity visible and reduces the chance of inserting them in the wrong place.

Working inside an Excel table

An Excel table is a structured range created with Insert > Table or Ctrl+T. Table rows are not quite the same thing as worksheet rows: the table has its own headers, filters, formatting, and calculated-column behavior. If your goal is to add a record to a table, click in its last cell and press Tab to create a new table row at the bottom. To add a row in the middle, right-click a cell in the table and look for the table-specific insert option, such as Insert > Table Rows Above.

When a cell inside a table is active, selecting and inserting a full worksheet row can affect the worksheet outside the table as well. That may be what you want, but it is different from adding only a table row. Use the table-specific command when you want to extend the table without deliberately inserting an entire sheet row. If you need a new field in the table, insert a table column rather than typing into a nearby worksheet column and assuming it has automatically become part of the table.

Before inserting within a table, consider formulas and references. Excel tables commonly extend calculated-column formulas and formatting to new rows, but the result can depend on how the workbook is set up. After adding a row or column, verify that the new cells are included in filters, formulas, charts, and any ranges used elsewhere in the workbook.

Excel on Mac and Excel for the web

In Excel for Mac, select the row with Shift+Space or the column with Control+Space, then try Control+Shift+= to insert. Keyboard behavior can differ with the Mac keyboard layout and the version of Excel, so the ribbon is a dependable fallback: select the destination and use the Insert commands on the Home tab. In particular, do not assume that the Windows Ctrl shortcut becomes Command; Excel for Mac uses different modifier conventions for some worksheet commands.

Excel for the web runs in a browser, where some key combinations can be intercepted by the browser or depend on the operating system. If the shortcut does not insert as expected, select the target row or column and use the ribbon’s Home > Insert command. This avoids confusion with browser shortcuts and makes the intended worksheet operation explicit. Menu labels and available options can vary slightly with the web interface, but inserting from the ribbon remains a practical alternative.

Common problems and quick fixes

The shortcut opens a dialog. You probably selected a cell or cell range rather than a complete row or column. Choose the row or column heading, or use Shift+Space or Ctrl+Space first.
The new space appears in the wrong place. Excel inserts above the selected row or to the left of the selected column. Select the row below or column to the right of the position where you want the blank space.
The shortcut types a plus sign or does nothing. Check that the worksheet has focus, and use the plus key combination for your keyboard layout. On a standard US layout, that is usually Ctrl+Shift+=. The ribbon command can confirm whether selection or keyboard focus is the issue.
Insert is unavailable. The sheet may be protected, or the workbook may restrict editing. Check the Review tab for sheet protection settings or ask the workbook owner for permission. Do not remove protection unless you are authorized to do so.
Only some cells seem to move. You may have inserted cells rather than a complete row or column. Undo immediately with Ctrl+Z if the result is unintended, then select a full row or column and repeat.
A table changes in an unexpected way. Use a table-specific row or column insertion command when your aim is to change the table structure, not the whole worksheet.

Before inserting into a shared or heavily formatted workbook, check for merged cells, formulas, named ranges, and charts that depend on nearby data. Excel generally adjusts many references when a row or column is inserted, but workbook design can include fixed ranges or external connections that do not adapt as expected. If the workbook is important, save a copy before making structural changes.

Choosing the right insertion method

Use the keyboard sequence when you need a quick, repeatable edit and can clearly identify the target. It is especially efficient for inserting one row or column, or a known number of them after selecting matching headings. Choose the ribbon when you are unsure whether Excel has selected a cell, a table row, or an entire worksheet row; the visible command helps clarify the operation. For an Excel table, prefer its context-specific insert options when the change should remain within the table.

A useful rule is to decide first whether you need a whole worksheet row, a whole worksheet column, or only a few cells. Then make that selection explicit before inserting. This small check prevents the most common mistake: shifting a handful of cells when you meant to make room across the entire sheet. If the sheet contains data in distant columns, remember that a full row insertion affects the whole worksheet row, not just the visible section of a report.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
Select the row with Shift+Space, then press Ctrl+Shift+= on Windows. Excel inserts a blank row above the selected row.

What is the shortcut to insert a column in Excel?
Select the column with Ctrl+Space, then press Ctrl+Shift+= on Windows. Excel inserts a blank column to the left of the selected column.

How do I insert a row below the current row?
Select the row immediately below the intended position, then insert. Excel places the new row above the selected row, so selecting the next row produces a blank row below the current one.

Can I insert multiple rows or columns at once?
Yes. Select as many complete rows or columns as you want to add, then use the insert shortcut or ribbon command. Excel inserts the same number of new rows or columns before the selection.

Why does Ctrl+Shift+= open an Insert dialog?
The selection is probably a cell or partial range rather than a complete row or column. Select the row or column first; the dialog is normal when Excel must ask how to shift selected cells.

Is the shortcut the same in Excel for Mac?
Excel for Mac commonly uses Control+Shift+=, but keyboard layouts and versions can affect the combination. If it does not work, use the Insert command on the Home tab.

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.