How to Add a New Line in Excel

The quickest way to add a line in Excel

To add a new row or column in Excel, right-click on the row number or column letter where you want the new line to appear, then select "Insert" from the menu. Excel will insert a blank row or column at that location and shift everything below or to the right down or over by one space. If you need to add multiple rows or columns at once, select as many row numbers or column letters as you want to insert, right-click, and choose "Insert" — Excel will add that many lines all at once.

You can also use the keyboard shortcut: select the row or column, then press Ctrl+Plus (on Windows) or Command+Plus (on Mac). A dialog box will appear asking whether you want to shift cells right or down; choose the direction that matches what you need, and Excel will insert the line.

Key Takeaways

Right-click the row number or column letter where you want a new line, then click "Insert" to add a blank row or column at that spot.
Select multiple row numbers or column letters at once to insert several rows or columns in a single action.
The keyboard shortcut Ctrl+Plus (Windows) or Command+Plus (Mac) inserts a line without using the menu.
When you insert a line, Excel automatically shifts existing data down or to the right so nothing gets overwritten.

Inserting rows in the middle of your data

If your spreadsheet already has data and you need to add a row somewhere in the middle, click on the row number of the row that will move down. For example, if you have data in rows 1 through 10 and you want to insert a new row between row 5 and row 6, click on the number "6" on the left side of the spreadsheet. The entire row 6 will highlight in blue.

Right-click on the highlighted row number and select "Insert 1" (or the number of rows you selected). Excel will create a blank row 6, and everything that was in row 6 and below will shift down one row. Your original row 6 becomes row 7, row 7 becomes row 8, and so on. All the formulas and references in those rows will update automatically so your calculations stay correct.

Inserting columns to the left or right

Adding a column works the same way as adding a row. Click on the column letter at the top of the spreadsheet — if you want to insert a column between columns B and C, click on the letter "C". The entire column will highlight.

Right-click the highlighted column letter and select "Insert 1" (or however many columns you selected). Excel will create a new blank column C, and everything that was in column C and to the right will shift one column to the right. If you have formulas that reference those columns, Excel updates them automatically so your spreadsheet keeps working the way you intended.

Inserting multiple rows or columns at once

When you need to add several rows or columns in one action, select them all before you insert. Click on the first row or column number you want to select, then hold Shift and click on the last one. For example, to select rows 5 through 8, click on "5", hold Shift, and click on "8". All four rows will highlight in blue.

Right-click anywhere in the highlighted area and select "Insert 4" (Excel will show the number of rows or columns you selected). Excel will insert that many blank rows or columns at the location of your first selection, and shift everything else down or to the right. This is faster than inserting one row or column four separate times.

What happens to formulas when you insert a line

If your spreadsheet contains formulas — like SUM, AVERAGE, or references to other cells — Excel automatically updates them when you insert a row or column. If a formula in cell D5 refers to cells A5 through C5, and you insert a new row 5, that formula moves to D6 and now refers to A6 through C6. The formula itself stays the same; only the cell references update.

However, if a formula refers to an entire column or row (like "=SUM(A:A)"), inserting a new row or column within that range does not change the formula at all — it already includes the new line. This is one reason why using entire column or row references can be useful in spreadsheets with data that changes size.

Undoing an inserted line if you make a mistake

If you insert a row or column by accident, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo the insertion. Excel will remove the line you just added and restore everything to where it was before. You can undo multiple actions in a row by pressing Ctrl+Z or Command+Z several times.

Be aware that if you inserted a line, added data to it, and then realize you made a mistake, undoing will remove both the line and the data you typed. If you have already saved the file after inserting the line, you cannot undo the insertion — you will need to delete the row or column manually instead.

Deleting rows or columns you no longer need

To remove a row or column, right-click on the row number or column letter and select "Delete". Excel will remove that line and shift everything below or to the right up or to the left to fill the gap. If you select multiple rows or columns before right-clicking, Excel will delete all of them at once.

Deleting is different from clearing: when you delete a row or column, the rows and columns below or to the right move up or left. When you clear a row or column (by selecting it and pressing Delete), the row or column stays in place but becomes empty. Use delete when you want to remove a line entirely, and use clear when you want to erase the contents but keep the structure of your spreadsheet the same.

Frequently Asked Questions

Can I insert a row at the very top or bottom of my spreadsheet?

Yes. To insert a row at the top, click on row 1, right-click, and select "Insert". A new row 1 will appear and your data shifts down. To add a row at the bottom, click on the row number below your last row of data and insert there. Excel will add the new row and you can start typing.

What if I insert a row but my data does not shift down?

This usually means you selected a cell instead of a row number. Make sure you are clicking on the actual row number on the left side of the spreadsheet (where it says 1, 2, 3, etc.), not on a cell within that row. The entire row should highlight in blue before you right-click.

Do I lose data when I insert a row or column?

No. When you insert a row or column, Excel shifts your existing data down or to the right to make room. Nothing is deleted or overwritten — it all moves to a new location. Your formulas update automatically so your calculations stay correct.

Can I insert a row between two specific cells instead of an entire row?

No. In Excel, you insert entire rows or columns, not partial ones. If you need to add data between two cells, you have to insert a full row or column and then delete the parts you do not need, or reorganize your data structure.

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.