You can insert rows and columns with shortcuts in Excel in just a couple of keystrokes, with no right-clicking or ribbon hunting required. The whole technique comes down to one combination, Ctrl + Shift + Plus (+), plus a quick selection of the row or column first. This guide walks through the exact keys for Windows and Mac so new rows and columns appear exactly where they are needed.
Key Takeaways
- Select a whole row or column first, then press Ctrl + Shift + Plus (+) on Windows to insert.
- Use Shift + Space to select a row and Ctrl + Space to select a column from the keyboard.
- Selecting several rows or columns first inserts that same number of new ones at once.
- On Mac, Control + Shift + Equal (=) inserts, and the selection shortcuts work the same way.
- New rows appear above the selection and new columns appear to the left of it.
Step-by-Step Guide to Insert Rows and Columns With Shortcuts
The process is the same for rows and columns: select first, then insert. Think of it like telling a seating planner which chair to move before asking for an extra seat to be added beside it.
Insert a Row With a Shortcut
- Step 1: Click any cell in the row where the new row should appear. The new row will be placed directly above this one.
- Step 2: Press Shift + Space to select the entire row.
- Step 3: Press Ctrl + Shift + Plus (+) on Windows. On the main keyboard, the plus sign shares a key with the equals sign, so this is the same as Ctrl + Shift + Equal (=). On a keyboard with a number pad, Ctrl + Plus on the pad also works without Shift.
- Step 4: Check that a blank row now sits above the original one, and that the old row has moved down.
Tip: If an entire row is already selected, the insert shortcut adds the row instantly. If only a single cell is selected, Excel opens a small Insert dialog instead, where choosing Entire row and pressing Enter does the same job.
Insert a Column With a Shortcut
- Step 1: Click any cell in the column where the new column should appear. The new column will be placed directly to the left of this one.
- Step 2: Press Ctrl + Space to select the entire column.
- Step 3: Press Ctrl + Shift + Plus (+) to insert the column.
- Step 4: Confirm that a blank column now appears to the left, with the original column shifted right.
Insert Multiple Rows or Columns at Once
This works best when several blank lines are needed in one go, for example when adding five new product entries to a price list. The key is to select the same number of rows or columns as the number to be added.
- Step 1: Select the first row or column where the insertion should begin, using Shift + Space for rows or Ctrl + Space for columns.
- Step 2: Hold Shift and press the Down Arrow to extend the selection across more rows, or press the Right Arrow to extend it across more columns. Selecting three rows will insert three rows.
- Step 3: Press Ctrl + Shift + Plus (+). Excel adds exactly as many blank rows or columns as were selected.
Tip: Right after inserting, press F4 or Ctrl + Y to repeat the last action. Most people find this is the fastest way to add another row or column of the same kind without reselecting anything.
Shortcuts for Mac
- Step 1: Select the row or column. The selection shortcuts are Shift + Space for a row and Control + Space for a column.
- Step 2: Press Control + Shift + Equal (=) to insert. Many Mac layouts also accept Command + Shift + Plus (+).
- Step 3: Check that the new blank row or column appeared in the right spot.
Common Problems and Fixes
The Insert Dialog Box Appears Instead of a New Row
This happens when only a single cell is selected rather than a whole row or column. Choose Entire row or Entire column in the dialog and press Enter, or press Esc, select the whole row or column first, and try the shortcut again.
The Shortcut Does Nothing
Make sure the Shift key is held along with Ctrl while pressing the plus key. On a laptop without a number pad, the plus sign sits on the equals key, so the shortcut only works when Shift is part of the combination.
Excel Says It Cannot Insert Cells
This message appears when the last row or column of the worksheet still contains data, because Excel cannot push content off the edge of the sheet. Clear or delete the data in the final row or column, then repeat the insertion.
The Insert Command Is Unavailable on a Protected Sheet
When the worksheet is protected, inserting rows and columns is blocked unless the protection allows it. Unprotect the sheet from the Review tab, insert the rows or columns, then protect the sheet again if needed.
Inserting Inside a Table Behaves Differently
When a cell inside an Excel table is selected, the shortcut inserts a table row or column rather than a full worksheet row or column. This keeps the table intact and is usually the desired result.
Frequently Asked Questions
What is the shortcut to insert a row in Excel?
Select the entire row with Shift + Space, then press Ctrl + Shift + Plus (+) on Windows. A blank row appears above the selected one.
What is the shortcut to insert a column in Excel?
Select the entire column with Ctrl + Space, then press Ctrl + Shift + Plus (+). A blank column appears to the left of the selected one.
Where does the new row or column appear?
A new row is placed above the selected row, and a new column is placed to the left of the selected column.
How do I insert several rows or columns at once with a shortcut?
Select the same number of rows or columns as the number needed, then press Ctrl + Shift + Plus (+). Excel inserts that exact number of blank rows or columns.
What is the Mac shortcut to insert rows and columns?
Select the row with Shift + Space or the column with Control + Space, then press Control + Shift + Equal (=). Many Mac keyboard layouts also accept Command + Shift + Plus (+).
Can the insert shortcut be repeated quickly?
Yes. After one insertion, press F4 or Ctrl + Y to repeat the last action, which adds another row or column in the current position.
Why does a dialog box open instead of inserting directly?
The dialog opens when only a single cell is selected. Selecting the whole row or column first lets the shortcut insert immediately without any prompt.
Does the Ctrl + Plus shortcut work on a laptop keyboard?
Yes, but Shift must be added because the plus sign shares a key with the equals sign. The combination is Ctrl + Shift + Plus (+). The Ctrl + Plus version without Shift works on a number pad.
Will formulas adjust after inserting a row or column?
Formulas that refer to cells below or to the right of the insertion point update their references automatically, so existing calculations keep pointing to the correct data.
