Multiple Rows - back to basics --> nothing techy here
Posted by jane ball on November 21, 2001 6:31 AM
Is there a quicker way of inserting multiple empty rows (a quick key) rather than simply selecting the number of rows that you need to insert then right mouse click->Insert?
Thank you
Posted by Russell Hauf on November 21, 2001 6:46 AM
What I have done is to put the Insert Rows and Insert Columns icons (actually buttons) on my toolbar. If you go to Tools-Customize, then select the Commands tab, select Insert under Categories, the second and third icons (buttons) should say Rows and Columns, respectively. If you just drag those 2 buttons to your toolbar, they will insert rows (or columns) where you have your active cell. You can hit these multiple times to keep inserting rows or columns, or you can select multiple rows or columns, and hit the appropriate button to insert that many rows or columns.
I hope I've explained this well and that it helps you,
Russell
Posted by Loren on November 21, 2001 7:29 AM
Re: Multiple Rows - using icons to insert or delete
Get opposite action from the icon by holding shift key
Posted by Juan Pablo on November 21, 2001 8:45 AM
[Ctrl] + [+] to insert and [Ctrl] + [-] to delete (NT)
Posted by Jane Ball on November 22, 2001 8:00 AM
Re: Thank you all for taking the time to reply to a newbie :-) x
