By
Elias Brandt
Elias Brandt writes about marketing, email and analytics tools for Appcyclopedia, working on a ThinkPad X1 Carbon Gen 10 and a Galaxy S25.
- Windows
- macOS
- Web
Short answer
Right-click the row number below where you want the new row, and choose Insert. To add several rows at once, select that many rows first, then right-click and choose Insert. On the Home tab, Insert, then Insert Sheet Rows does the same.
New rows go above your selection: select the row that should end up below the new one.
Below: the steps, inserting many rows at once, the formatting new rows get, and inserting columns.
How to add rows to an Excel sheet
To insert rows in Excel, select where they should go, then choose Insert. The first group adds one row, the second several, and the last sets the formatting.
-
Insert one row
Right-click the row number below the new row
Find the row that should end up directly under the new one, and right-click its number on the left edge of the sheet. A menu opens.
-
Choose Insert
Select Insert. A blank row appears above the one you clicked, and everything below moves down by one. Formulas that refer to those rows adjust automatically.
-
Insert several rows
Select as many rows as you want to add
Click the first row number and drag down, or hold Shift and click, to select the same number of rows you want to insert. To add five rows, select five.
-
Right-click the selection and choose Insert
Right-click anywhere in the selected row numbers and choose Insert. Excel adds that many blank rows above the selection.
-
Or use Home, Insert, Insert Sheet Rows
With a cell or rows selected, go to the Home tab, select Insert, then Insert Sheet Rows. It does the same as the right-click menu.
-
Set the formatting
Choose the formatting with Insert Options
A new row copies the formatting of the row above it. Select the Insert Options button that appears to choose formatting from the row below, or clear it.
A forgotten expense in the middle of a monthly list: right-click row 12, where the new item belongs, and choose Insert. A blank row appears above, the rows below move down, and a SUM at the bottom still covers the whole list.
Select as many rows as you need to add before inserting: Excel adds exactly that many in one go.

More about Microsoft Excel
Microsoft’s spreadsheet app, free on the web with a Microsoft account.
If Excel will not insert a row
- Excel says it cannot shift cells off the sheet
There is data or formatting near the very bottom of the sheet. Delete the unused rows at the end, save, and try again.
- Insert is greyed out
The sheet may be protected, or you are editing a cell. Press Esc, and unprotect the sheet from the Review tab if needed.
- The Insert Options button does not appear
It may be turned off. Go to File, Options, Advanced, and under Cut, copy, and paste tick Show Insert Options buttons.
Ways to insert rows
Three routes do the same job; pick whichever is closest.
| Method | How | Good for |
|---|---|---|
| Right-click row number | Insert from the menu | One or a few rows, quickly |
| Select several, then insert | Select rows, right-click, Insert | Many rows at once |
| Ribbon | Home, Insert, Insert Sheet Rows | When you prefer menus |
Right-click the row number: it is the quickest way, and selecting several first inserts that many.
Rows and formulas
Inserting a row inside a range that a formula uses, such as a SUM over a column, makes the range grow so the formula keeps counting everything. A row added just below the end of the range may not be included, so check the formula’s range after adding rows at the edges.
What to do after inserting rows
Fill in the new rows, then check any totals below them still cover the full range.
Right-click the row number below where you want the row and choose Insert. To add up the column afterwards, the guide to adding up a column in Excel covers AutoSum.
Inserting rows in Excel, answered
- Where does the new row go?
- Above the row you selected. Select the row that should end up below the new one.
- Do formulas update when I insert a row?
- Yes, for references that cover the area. A SUM over a range grows to include a row inserted inside it.
- How do I insert a column instead?
- Right-click a column letter and choose Insert. The new column appears to the left of the one you selected.
- How do I delete a row?
- Right-click the row number and choose Delete. The rows below move up.
Share this guide
Link copied
Was this guide helpful?
What was missing?
Thanks, that helps us.
Test log
Followed the steps? Tell us how it went on your device. Entries appear here after we check them.
- Worked Every step, start to finish · Elias Brandt and Daniel Okonkwo Team
I tested this
Steps performed and confirmed 26 days ago
When you need this
To add a row in the middle of an Excel sheet, right-click the row number and choose Insert. Select several rows first to add that many at once.
- Describes
- Excel for Microsoft 365 on Windows · Excel for the web
- Takes
- A few seconds
- Platforms
- Windows · macOS · Web
- Published
- 23 October 2026
- Facts checked
- 22 October 2026
Steps repeated and verified by
Elias Brandt and
Daniel Okonkwo
on
- Elias Brandt: the Windows and web steps on a ThinkPad X1 Carbon (Windows 11 Pro).
- Daniel Okonkwo: the Mac steps on a MacBook Pro (macOS 27.0.1).