Insert row excel

Question

I would very much like for an insert row 'below' to be an option within Excel.

our normal use of Excel is with formatted gant charts and trackers etc and insert option currently with 'above only' creates an awful lot of wasted time maintaining and correcting formatting etc,

Insert below would reduce inefficiency.

Answer 1

Hello !

The AI answer is correct. The desktop version of Excel always inserts rows above and columns on the left.
There's no way to modify this behaviour.

However, if you really need the option to insert above or below, Excel on the Web has this feature.

If your Excel worksheets are not too complex, you should able to use the web version.

Otherwise, you can leave feedback by opening desktop Excel > Help tab on the Ribbon > Feedback.

Please let me know if you have any other question !

Answer 2

Excel supports inserting rows both above and below the current position, depending on how the command is used.

For standard ranges (not Excel Tables):

1. Select any cell in the row where the new row should go.
2. On the Home tab, select Insert > Insert Sheet Rows.
   • This inserts a row above the active row. Excel’s built‑in sheet row insert is always “above” for normal ranges.

For Excel Tables (structured tables), there is an explicit “insert below” option via keyboard or screen reader commands:

Using keyboard (Windows):

1. Move to the row in the table where the new row is needed.
2. Press Alt+H, I to open the Insert menu.
3. Press:
   • A to insert a row above the current row.
   • B to insert a row below the current row (available when on the last row of the table).

Using a screen reader (Windows):

1. Navigate to the desired row in the table.
2. Press F6 until the Home tab is selected.
3. Tab to Insert, menu button, then open it.
4. Choose:
   • Insert table rows above to insert above.
   • Insert table row below to insert below (only when on the last row).

On mobile with a screen reader:

1. Navigate into the table and to the cell where the new row is needed.
2. Open the Table tab from the tab menu.
3. Use:
   • Insert above to add a row above.
   • Insert below to add a row below.

For Gantt charts and trackers, converting the range to an Excel Table will provide a more flexible “insert below” experience and help maintain formatting automatically as rows are added.

---

References:

• Insert or delete rows and columns in Excel
• Use a screen reader to insert a table in an Excel worksheet