The quickest keyboard shortcut to add a row in Excel
Right-click on the row number where you want the new row to appear, then click Insert. That is the most reliable method across all versions of Excel. If you want a keyboard-only approach, select the row by clicking its number, then press Ctrl (Windows) or Command (Mac), then right-click and select Insert — but the mouse method is faster for most people.
Excel does not have a single keyboard shortcut that works the same way on every computer and every version. The reason is that Excel's shortcuts depend on your operating system, your version of Excel, and whether you are using Excel online or the desktop app. A shortcut that works on Windows 10 may not work on a Mac, and a shortcut that works in Excel 2019 may not work in Excel 365.
The right-click method works everywhere because it uses Excel's menu system, which is the same across all versions. Once you learn this one method, you can add rows anywhere without hunting for the right keyboard combination.
Key Takeaways
- Right-click the row number where you want a new row, then click Insert — this works on every version of Excel and every operating system.
- You can insert multiple rows at once by selecting multiple row numbers before right-clicking.
- The new row appears above the row you selected, not below it, so choose your target row carefully.
- If you are using Excel online, the right-click menu works the same way as the desktop version.
How to insert a single row step by step
Click on the row number on the left side of the spreadsheet where you want the new row to go. The entire row will highlight in blue. For example, if you want to add a row between row 5 and row 6, click on the number 6.
Right-click on that row number. A menu will appear with several options. Click the word Insert. A new blank row will appear above the row you selected, and all the rows below it will shift down by one.
If you accidentally insert a row in the wrong place, press Ctrl + Z (Windows) or Command + Z (Mac) to undo it, then try again. This works when ready after the insert, so you can fix mistakes without losing any data.
Adding multiple rows at the same time
If you need to add three rows at once instead of one, select three row numbers before you right-click. Click on the first row number, then hold Shift and click on the third row number. All three rows will highlight in blue.
Right-click on any of the highlighted row numbers and click Insert. Excel will add three new blank rows above the first row you selected. This is much faster than inserting one row three times in a row.
You can select as many rows as you need this way. If you need to add 10 rows, select 10 row numbers, then insert them all at once. The rows will appear in the same block, all together.
Why the new row appears above, not below
Excel always inserts the new row above the row you selected. This catches people off guard because they expect the new row to appear below. If you want a new row between row 5 and row 6, you have to click on row 6 first, not row 5.
Think of it this way: you are telling Excel "insert a new row here," and "here" means at the position of the row you clicked. The selected row and everything below it shift down to make room.
Once you know this rule, it becomes automatic. You will start clicking on the row number below where you want the new row to go, and it will feel natural.
Using the menu instead of right-clicking
If right-clicking does not work on your computer or you prefer using menus, you can insert a row from the top menu bar. Select the row number first, then click Home (or Sheet on some versions), then look for a button that says Insert or has a small arrow next to it.
Click that button and select Insert Sheet Rows Above or Insert Rows Above depending on your version. The new row will appear in the same place as the right-click method.
The menu method takes more clicks than right-clicking, so most people use right-click once they know it works. But if your mouse is not working or you prefer keyboard navigation, the menu is always there.
What happens to formulas and data when you insert a row
If the rows below your new row contain formulas, those formulas will move down with the row numbers. For example, if row 10 contains a formula that adds up row 9, and you insert a new row at row 9, the formula will now add up row 10 instead. Excel adjusts the formula automatically.
If you have data in the rows below, that data moves down too. Nothing is deleted or lost — everything just shifts down by one row number. This is why inserting a row in the middle of a table is safe; your data stays intact and your formulas keep working.
The only exception is if you have a formula that refers to a specific row number by name, like "always use row 50." When you insert a row, that formula will not change, and it may now point to the wrong data. This is rare in most spreadsheets, but it is worth checking if you have very old or complex formulas.
Inserting rows in Excel online versus desktop Excel
Excel online (the version you use in a web browser) works the same way as desktop Excel for inserting rows. Right-click the row number, click Insert, and the new row appears above the selected row. The menu method also works the same way.
The main difference is speed. Desktop Excel is usually faster because it does not have to send information back and forth to Microsoft's servers. Excel online may take a second or two longer to insert a row, especially if your internet connection is slow.
If you are switching between Excel online and desktop Excel, you do not have to learn two different methods. The right-click method works on both, so you can use the same steps no matter which version you are using.
Frequently Asked Questions
Can I insert a row at the very top of the spreadsheet?
Yes. Click on row number 1, right-click, and click Insert. A new row will appear above row 1 and become the new row 1. All the other rows shift down. This works the same way as inserting a row anywhere else in the spreadsheet.
What if I insert a row by accident?
Press Ctrl + Z (Windows) or Command + Z (Mac) when ready to undo the insert. The row will disappear and all your data will return to its original position. You can undo multiple times if you inserted several rows by mistake.
Can I insert a row without using the right-click menu?
Yes. Select the row number, then use the Home menu at the top and look for an Insert button. Some versions of Excel also let you use Alt + I + R on Windows, but this shortcut does not work on all computers, so right-click is more reliable.
Do I lose any data when I insert a row?
No. Inserting a row pushes all the data below it down by one row. Nothing is deleted. If you insert a row in the middle of a table, the table expands by one row and all your data stays intact.
Can I insert rows in the middle of a table without breaking it?
Yes. Inserting a row in the middle of a table is safe. The table expands, all the data moves down, and any formulas that reference the table adjust automatically. Excel treats the table as a unit and keeps it working.