How to Add Rows and Columns in Excel Spreadsheets

The quickest ways to insert rows and columns

You can add a row or column to an Excel spreadsheet in three clicks or fewer. Right-click on the row number or column letter where you want the new line to appear, then click "Insert" from the menu that pops up. Excel inserts the new row above the one you clicked, or the new column to the left of the one you clicked. If you need to add multiple rows or columns at once, select as many as you want to insert before right-clicking — Excel will add that many new lines in one action.

The keyboard shortcut is faster if your hands are already on the keyboard. Select the row or column, then press Ctrl + Plus (Windows) or Cmd + Plus (Mac). A small dialog box appears asking whether you want to shift cells right or down; choose the direction and click OK. This method works the same way whether you are inserting one line or ten.

Both methods preserve your existing data — nothing gets deleted, only moved. Formulas that reference cells in the rows or columns you moved will automatically update to point to the new locations.

Key Takeaways

Right-click a row number or column letter and select Insert to add a new line in that location, with existing data shifting down or to the right.
Select multiple rows or columns before inserting if you need to add more than one at a time.
Excel automatically updates any formulas that reference cells in the moved rows or columns.
The keyboard shortcut Ctrl+Plus (Windows) or Cmd+Plus (Mac) inserts rows or columns without using the mouse.
New rows appear above the row you selected; new columns appear to the left of the column you selected.

Inserting a single row or column

Click on the row number (the gray box on the left side showing 1, 2, 3, and so on) or the column letter (A, B, C, and so on) to select the entire row or column. The whole row or column will highlight in blue. Right-click anywhere on that highlighted area and choose "Insert" from the menu.

A new row will appear above the row you selected, or a new column will appear to the left of the column you selected. All the data that was in that row or column, and everything below or to the right of it, shifts down or to the right by one position. If you had data in row 5 and inserted a new row at row 5, your old row 5 data moves to row 6.

Adding multiple rows or columns at once

If you need to add five new rows between your headers and your data, you do not have to insert them one at a time. Click on row 10, then hold Shift and click on row 14. This selects rows 10 through 14 — five rows total. Now right-click and choose Insert. Excel adds five new blank rows above row 10, and your old rows 10 through 14 shift down to rows 15 through 19.

The same method works for columns. Click on column C, hold Shift, and click on column G to select five columns. Right-click and insert. Five new blank columns appear to the left of column C, and your old columns C through G shift to the right.

You can also select non-consecutive rows or columns by clicking the first one, then holding Ctrl (Windows) or Cmd (Mac) and clicking the others. However, Excel will insert one new row or column for each one you selected, and they will not all appear in the same place — this is useful only if you need to add lines in several different spots in the same spreadsheet.

What happens to formulas when you insert rows or columns

If you have a formula that adds up cells in column B, and you insert a new column B, Excel automatically updates the formula to include the new column in its calculation. This is one of the biggest advantages of using spreadsheets instead of static documents — the math stays correct even when you reorganize.

The only exception is if your formula uses an absolute reference, which is a cell address with dollar signs in it (like $B$5 instead of B5). Absolute references do not change when you insert rows or columns. If you intentionally used an absolute reference because you wanted that cell to stay fixed no matter what, the formula will work the way you designed it. If you used it by accident, you may need to edit the formula after inserting the row or column.

Undoing an insertion if you made a mistake

If you inserted a row or column and when ready realized it was the wrong place, press Ctrl+Z (Windows) or Cmd+Z (Mac) to undo. This works as long as you have not done anything else in the spreadsheet since the insertion. If you have made other changes, undo will reverse all of them, not just the insertion.

If you inserted the row or column in the right place but at the wrong time, you can delete it later by right-clicking the row or column number and choosing Delete. This is different from clearing the contents — Delete removes the row or column entirely and shifts everything else up or to the left. Clear Contents (also in the right-click menu) empties the cells but leaves the row or column in place.

Inserting rows or columns in the middle of a table

When you insert a row or column in the middle of existing data, Excel does not automatically expand any table formatting you may have applied. If you have a table with colored headers and alternating row colors, inserting a new row will add a blank row with the same formatting, but you may need to manually adjust borders or other styling.

To avoid this, convert your data to an official Excel table before inserting rows. Select all your data including headers, then go to the Insert tab and click Table. Now when you insert rows or columns, Excel treats them as part of the table and applies the same formatting automatically. You can also add rows by clicking the last cell in the table and pressing Tab — Excel will create a new row at the bottom with all the formatting already in place.

Inserting rows or columns using the menu

If you prefer not to right-click, you can use the menu bar instead. Select the row or column where you want to insert, then click the Home tab. In the Cells group on the far right, click the dropdown arrow next to "Insert" and choose "Insert Sheet Rows" or "Insert Sheet Columns." This method takes more clicks than right-clicking, but it works the same way.

On a Mac, the menu bar at the top of the screen has Sheet, Edit, and other options. Click Sheet, then look for Insert Rows or Insert Columns. The location varies depending on your version of Excel, so if you cannot find it, right-clicking is usually faster.

Frequently Asked Questions

Can I insert a row between two specific rows without affecting the rest of the spreadsheet?

No — inserting a row shifts everything below it down by one position. If you want to add data without moving existing rows, you can add it at the bottom of your spreadsheet instead, or delete a blank row elsewhere to make room. You cannot insert a row in isolation.

What is the difference between inserting and adding a row at the bottom?

Inserting a row moves all existing data down. Adding a row at the bottom (by clicking the last cell and pressing Tab, or by clicking an empty row below your data) does not move anything — it just fills in blank space that was already there. Use insert when you need the new row in a specific location; use add-at-bottom when you are extending your data.

If I insert a column, will my column letters change?

Yes. If you insert a new column between A and B, the old column B becomes column C, and all your formulas update automatically. This is why Excel formulas are more reliable than manually typed references — the spreadsheet keeps track of where everything moved.

Can I insert a row without selecting the entire row first?

You can click any cell in the row where you want to insert, then right-click and choose Insert. Excel will insert a new row above that cell. However, selecting the entire row by clicking the row number is clearer and less likely to cause mistakes, especially if you are inserting multiple rows.

What happens if I insert a row in a spreadsheet that has frozen panes?

The new row inserts in the normal location — above the row you selected — and the frozen panes stay in place. If you froze rows 1 through 3 and insert a new row at row 5, rows 1 through 3 remain frozen, and row 5 becomes a new blank row with row 6 and below shifting down. Your freeze settings do not change.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.