How can I insert rows BELOW, in Excel
 

How can I insert a row BELOW the currently selected row?

In Excel 2003, after selecting a row, I could go to the Table menu and
click insert rows below. Now the only option seems to be on the Home ribbon,
cells group, insert button then insert sheet row, which does so ABOVE the
selected row only.

I am trying to insert a row at the bottom of a table that preserves the
formatting of the table so that I can enter new data and have that at the
bottom of the table. The only other way is to insert above and then copy the
final row into the inserted row and then clear out the bottom row. This is a
real pain. Why did this feature disappear?

Answer: How can I insert rows BELOW, in Excel
 

To insert a row BELOW the currently selected row in Excel, you can follow these steps:

1. Select the row below where you want to insert the new row.
2. Right-click on the selected row and choose "Insert" from the context menu.
3. In the "Insert" dialog box, select "Entire row" and click "OK".

Alternatively, you can use the "Insert" button on the Home ribbon, as you mentioned, but make sure to select "Insert Sheet Rows" instead of "Insert Sheet Columns". This will insert a new row BELOW the currently selected row.

As for why the "Insert Rows Below" option disappeared from the Table menu, it's possible that it was removed in newer versions of Excel to streamline the user interface. However, the above methods should still allow you to insert a row below the selected row.

How can I insert rows BELOW, in Excel
 

On 4/12/2010 3:24 PM, Scott wrote:
How can I insert a row BELOW the currently selected row?

In Excel 2003, after selecting a row, I could go to the Table menu and
click insert rows below. Now the only option seems to be on the Home ribbon,
cells group, insert button then insert sheet row, which does so ABOVE the
selected row only.

I am trying to insert a row at the bottom of a table that preserves the
formatting of the table so that I can enter new data and have that at the
bottom of the table. The only other way is to insert above and then copy the
final row into the inserted row and then clear out the bottom row. This is a
real pain. Why did this feature disappear?

First create a Table using Ctrl-T
Then go to the bottom row and right click any cell in it. From the drop
down menu, click Insert, then select Insert Rows Above.

Bill