Download Article
Learn how to insert one or more rows at a time in Excel
Download Article
Trying to insert or delete rows in your Microsoft Excel worksheet? You can add one or more rows using a keyboard shortcut. Or, if you're trying to delete rows, you can select them and use the right-click menu to remove them from your spreadsheet. This process can even be used to insert or delete columns. This wikiHow guide will show you how to insert rows in Excel using your Windows or Mac computer.
Adding One or Multiple Rows in Excel
To insert rows in Excel using a keyboard shortcut, select the row number above where you want the new row. If you want to add multiple rows, select multiple row numbers. Then, press CTRL + Shift + ( + ) on Windows or CMD + Shift + ( + ) on Mac.
Steps
-
Click the row number above which you want to insert a row. This will select and highlight the entire row. After making a spreadsheet in Excel , you sometimes need to insert rows between existing rows. This method does exactly that.
- You can select multiple rows to insert that amount of rows above the selection. To select more than one row, hold CTRL (Windows) or CMD (Mac) as you click each row.
- For example, if you want to insert three blank rows above row 17, select rows 17, 18, and 19.
- You can also do the same with columns; just select a column.
-
Press Ctrl + ⇧ Shift + + (Windows) or ⌘ Cmd + ⇧ Shift + + (Mac). This will insert one or more rows (depending on how many you selected) above the selected rows. [1] X Research source
Advertisement
-
Select the sheet into which you’ll insert rows. In your Excel workbook file, at the lower-left corner of the worksheet, are some tabs. These tabs can either be labeled Sheet1, Sheet2, etc., or renamed to a name you prefer. Click on the sheet you will insert rows into.
-
Select a row. Do this by clicking on the number of the row found on the left of the screen. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- For example, if you’re tracking your bills in Excel and want to add a purchase that you forgot to input, you can select the row below where you want to insert the new line.
- You can also do the same with columns; just select a column.
-
Right-click the selected row. A context menu will pop up.
-
Select Insert . A row will be inserted above the one you selected. [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- Select Delete instead if you want to delete the selected row.
Advertisement
-
Select the sheet into which you’ll insert rows. In your Excel workbook file, at the lower-left corner of the worksheet, are some tabs. These tabs can either be labeled Sheet1, Sheet2, etc., or renamed to a name you prefer. Click on the sheet you will insert rows into.
-
Select the number of rows you want to insert. To insert multiple rows, highlight the rows below where you want to insert rows. Highlight the same number of rows as you want to insert. [4] X Research source
- For example, if you want to insert four new rows, select four rows.
- You can select multiple rows by clicking the first row number, holding Shift , then clicking the last row number.
- You can also do the same with columns.
-
Select Insert . The number of rows you highlighted will be inserted above the rows you selected. [6] X Research source
- Select Delete instead if you want to delete the selected rows.
- Functions like the SUM Function will change their cell reference range when you insert rows. If you’re using a VLOOKUP function , you may need to re-enter the range depending on the structure of your formula.
Advertisement
-
Select the sheet into which you’ll insert rows. In your Excel workbook file, at the lower-left corner of the worksheet, are some tabs. These tabs can either be labeled Sheet1, Sheet2, etc., or renamed to a name you prefer. Click on the sheet you will insert rows into.
-
Select the rows. To insert nonadjacent rows, hold down the CTRL key (Windows) or CMD key (Mac) and select nonadjacent rows by left-clicking the row numbers using your mouse.
- For example, you could select three nonadjacent rows to insert a new row above each selected row.
- You can also do the same with columns; just select the columns.
-
Right-click the selected rows. A context menu will pop up.
-
Select Insert . The number of rows you highlighted will be inserted above the rows you selected.
- Select Delete instead if you want to delete the selected rows.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
- ↑ https://edu.gcfglobal.org/en/excel-tips/add-a-new-row-with-a-shortcut/1/
- ↑ https://support.microsoft.com/en-us/office/insert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246
- ↑ https://support.microsoft.com/en-us/office/insert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246
- ↑ https://www.geeksforgeeks.org/how-to-insert-multiple-rows-in-microsoft-excel/
- ↑ https://www.geeksforgeeks.org/how-to-insert-multiple-rows-in-microsoft-excel/
- ↑ https://www.geeksforgeeks.org/how-to-insert-multiple-rows-in-microsoft-excel/
About This Article
Thanks to all authors for creating a page that has been read 198,840 times.
Advertisement
