LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a key to insert rows in excel? cravingmad Excel Discussion (Misc queries) 6 October 17th 08 12:17 PM
How can I insert a blank row after every four rows in Excel? EmmaSB Excel Discussion (Misc queries) 2 April 20th 07 10:10 PM
Excel Macro to insert rows Dhawal Excel Discussion (Misc queries) 3 October 2nd 06 01:16 AM
how do you have rows automatically insert in excel? Shelvonne Excel Worksheet Functions 0 November 10th 05 12:37 AM
how to auto insert rows in Excel TanyaG Excel Discussion (Misc queries) 2 July 4th 05 07:58 PM


All times are GMT +1. The time now is 02:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"