The simplest way to insert a row or column

To add a line in Excel, right-click on the row or column number where you want the new line to appear, then select Insert from the menu that pops up. Excel will create a blank row or column at that spot and shift everything below or to the right down or over by one. This takes about three seconds and works the same way in Excel on Windows, Mac, and the web version.

The row or column you right-click on is where the new line will go — not after it. So if you right-click on row 5, your new blank row becomes row 5, and what was row 5 moves down to row 6. This matters when you are inserting in the middle of data.

You can also select multiple rows or columns at once and insert that many lines in one action. Click on the first row number, hold Shift, and click on the last row number you want selected. Then right-click and choose Insert. If you select three rows, Excel will add three new blank rows.

Key Takeaways

  • Right-click the row or column number where you want the new line, then select Insert from the menu.
  • The new line appears at the row or column you clicked on, pushing existing data down or to the right.
  • You can insert multiple rows or columns at once by selecting them first while holding Shift.
  • Inserted rows and columns are always blank — they do not copy formatting or formulas from nearby cells.
  • Use Ctrl+Z (or Command+Z on Mac) when ready if you insert in the wrong spot.

Inserting a row at the end of your data

If you want to add a line at the bottom of your spreadsheet, you do not need to right-click. straightforward click on the first empty cell below your data and start typing. Excel treats any cell you type into as part of your data, so the new row becomes part of your sheet automatically.

This is the fastest way when you are adding data to the end — no menu, no right-click. Just click and type. Excel will also auto-fill some patterns if you have been consistent. For example, if column A contains January, February, March, and you type into the next cell, Excel will suggest April.

When you need to insert a column instead

Inserting a column works exactly like inserting a row, but you right-click on the column letter at the top instead of a row number on the left. Right-click on column C, select Insert, and a new blank column C appears. Everything that was in column C shifts one column to the right and becomes column D.

Columns are useful when you realize you forgot to track something. For example, if you have Name in column A and Email in column B, but you want Phone in between them, right-click on column B, insert a column, and now Phone goes in the new column B while Email moves to column C.

Inserting multiple lines at once

When you need to add several blank rows or columns in the same place, select as many as you want to insert before you right-click. Click on row 10, then hold Shift and click on row 15. You now have rows 10 through 15 selected (shown in blue). Right-click anywhere in the selection and choose Insert. Excel will add six new blank rows starting at row 10.

This saves time when you are restructuring a spreadsheet or making room for a block of new data. The number of rows or columns you select is the number that will be inserted.

What happens to formulas and formatting

When you insert a new row or column, any formulas in nearby cells do not automatically adjust to include the new line. If you have a SUM formula that adds rows 1 through 5, and you insert a new row 3, the formula still adds rows 1 through 5 — it skips your new row 3. You will need to edit the formula yourself to include the new row if that is what you want.

Formatting (like bold text, colors, or borders) also does not copy to the new blank row or column. The inserted line is completely blank and unformatted. If you want it to match the rows around it, you can copy the formatting from a nearby row, paste it into the new row, and then add your data.

Undoing an insertion you did not mean to make

If you insert a row or column in the wrong place, press Ctrl+Z on Windows or Command+Z on Mac when ready. This undoes the insertion and puts everything back where it was. You can undo multiple times if you made several insertions in a row.

Undo works best right after you make the mistake. If you have made many other changes since the insertion, undoing will reverse all of those changes too, so you may lose work. In that case, it is faster to delete the row or column you inserted by mistake and manually move your data back.

Deleting a row or column you no longer need

To remove a row or column, right-click on its number or letter and select Delete instead of Insert. Everything below or to the right shifts up or to the left to fill the gap. This is the opposite of inserting — you are removing a line and closing the space.

Be careful when deleting because it removes all data in that row or column. If you delete row 5 by mistake and it had important numbers in it, undo when ready with Ctrl+Z or Command+Z. Once you have made other changes, the data is harder to recover.

Frequently Asked Questions

Can I insert a row in the middle of a formula?

Yes, but the formula will not automatically include the new row. If you have a SUM formula that adds rows 1 through 10, and you insert a new row 5, the formula still only adds the original rows 1 through 10 (skipping your new row 5). You must edit the formula to include the new row if you want it counted.

What is the difference between inserting and just adding data to an empty row?

Inserting pushes existing data down or to the right, which is useful when you need to add a line in the middle of your spreadsheet. Adding data to an empty row at the bottom does not move anything. Use Insert when you need the new line in a specific spot; use an empty row when you are adding to the end.

Can I insert a row without right-clicking?

Yes. Select the row where you want to insert by clicking its number, then go to the Home tab at the top and click the dropdown arrow next to Insert. Choose Insert Sheet Rows. This does the same thing as right-clicking but works if your right-click menu is not responding.

Will inserting a row change my file size?

No. Inserting blank rows does not make your file noticeably larger. Excel only stores data you have actually entered, so blank rows take almost no space. Deleting rows you do not need can make your file slightly smaller, but the difference is usually tiny unless you delete thousands of rows.

What if I insert a row but do not see it appear?

The row was inserted, but you may be looking in the wrong place. Remember that the new row appears at the row number you right-clicked on, not after it. Scroll up and down to find it, or press Ctrl+Z to undo and try again, paying close attention to which row number you click.