Adding rows and columns is the most basic edit you'll make in Excel
To add a row, right-click on the row number on the left side of the spreadsheet and select Insert 1 from the menu. Excel will insert a blank row directly above the row you clicked. To add multiple rows at once, click on one row number, then hold Shift and click on another row number to select a range — right-click and select Insert, and Excel will add as many blank rows as you had selected.
To add a column, right-click on the column letter at the top of the spreadsheet and select Insert 1. Excel will insert a blank column directly to the left of the column you clicked. The same Shift-click method works for columns: select the range you want, right-click, and choose Insert.
When you insert a row or column, any data that was below or to the right shifts down or over automatically. Formulas that reference cells in your spreadsheet will update to point to the new locations, so you won't break calculations by adding rows in the middle of your data.
Key Takeaways
- Right-click the row number or column letter and select Insert 1 to add a single row or column in that location.
- Select multiple row numbers or column letters using Shift-click, then right-click and choose Insert to add several rows or columns at once.
- New rows appear above the row you clicked, and new columns appear to the left of the column you clicked.
- Any data below a new row or to the right of a new column shifts automatically, and formulas update to match the new cell locations.
Inserting rows in the middle of existing data
If you have data already in your spreadsheet and need to add a row between two existing rows, the process is the same. Click the row number of the row that should come after your new row, right-click, and select Insert 1. For example, if you have data in rows 1 through 10 and want to add a new row between row 5 and row 6, click on row 6, right-click, and insert. The old row 6 becomes row 7, and your new blank row sits at row 6.
This matters because it means you control exactly where the new row lands. If you click the wrong row number, you can undo the insertion by pressing Ctrl+Z (or Cmd+Z on Mac) and try again.
Adding columns to the left or right of existing data
Columns work the same way as rows. If you want a new column to appear between two existing columns, click the column letter of the column that should come after your new column, right-click, and select Insert 1. The new column always appears to the left of the column you clicked.
This is different from how many people expect it to work — they often think "insert after column B" means the new column goes to the right of B. In Excel, you have to click the column that will move over, not the column you want the new one next to. Once you do this a few times, it becomes automatic.
Using the menu instead of right-clicking
If right-clicking doesn't work on your device or you prefer using the menu, you can insert rows and columns from the top menu bar. Click the row number or column letter to select it, then click the Home tab. In the ribbon, find the Insert button (it usually has a small dropdown arrow next to it), click it, and select Insert Sheet Rows or Insert Sheet Columns.
The menu method takes more clicks than right-clicking, but it works the same way and gives you the same result. Some people find it easier to remember because the menu is always visible at the top of the screen.
Deleting rows and columns you no longer need
If you add a row or column by mistake, or if you have data you want to remove, right-click the row number or column letter and select Delete. This removes the row or column entirely and shifts everything below or to the right up or to the left to fill the gap. Unlike clearing the contents (which leaves the row or column in place but empty), deleting actually removes the row or column from the spreadsheet.
Be careful when deleting rows or columns that contain data — Excel will ask you to confirm, but once you confirm, the data is gone. If you delete by mistake, press Ctrl+Z when ready to undo.
What happens to formulas when you add rows or columns
If your spreadsheet contains formulas that reference cells, those formulas update automatically when you insert rows or columns. For example, if you have a formula in cell D5 that adds up cells D1 through D4, and you insert a new row at row 3, the formula will change to add D1 through D5 instead — it expands to include the new row. This is almost always what you want, because it keeps your calculations correct.
The only time this causes problems is if you have a formula that deliberately references a specific range and you don't want it to expand. This is rare in basic spreadsheets, but if it happens to you, you can undo the insertion and use a different approach.
Frequently Asked Questions
Can I add a row at the very bottom of my data?
Yes. Click the row number below your last row of data, right-click, and select Insert 1. You can also click any empty row below your data and start typing — Excel will add rows automatically as you fill them in. The second method is faster if you're just adding a few rows at the end.
What's the difference between inserting and just typing in an empty row?
If you have empty rows scattered throughout your spreadsheet, typing in them doesn't change anything. But if you want to add a row between two rows of existing data, you must use insert, not just find an empty row somewhere else. Insert puts the new row in the exact spot you choose and shifts everything else over.
If I insert a row, will it mess up my formulas?
No. Excel updates formulas automatically when you insert rows or columns. If a formula was adding up a range of cells, it will expand to include the new row. This is the default behavior and almost always correct.
Can I undo an insertion if I change my mind?
Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after inserting. You can undo multiple times to go back several steps if needed. Once you save the file, you can no longer undo changes from before you saved.