Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up a key to insert rows in excel? | Excel Discussion (Misc queries) | |||
How can I insert a blank row after every four rows in Excel? | Excel Discussion (Misc queries) | |||
Excel Macro to insert rows | Excel Discussion (Misc queries) | |||
how do you have rows automatically insert in excel? | Excel Worksheet Functions | |||
how to auto insert rows in Excel | Excel Discussion (Misc queries) |