Skip to content
Appcyclopedia
Microsoft Excel guide

How to insert rows in Excel

· 1 min task · Tested

By

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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

MethodHowGood for
Right-click row numberInsert from the menuOne or a few rows, quickly
Select several, then insertSelect rows, right-click, InsertMany rows at once
RibbonHome, Insert, Insert Sheet RowsWhen 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

Was this guide helpful?

Test log

Followed the steps? Tell us how it went on your device. Entries appear here after we check them.

  1. Worked Every step, start to finish · Elias Brandt and Daniel Okonkwo Team
I tested this
How did it go?

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 and 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).

Next

excelrowsgetting started