Can someone advise me how to insert more than 1 row a time.
Thanks,
Scott
Niek Otten - 10 May 2008 16:25 GMT
Hi Scott,
If you select 5 rows and then hit the Insert>Sheet Rows button, Excel will insert 5 rows

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Can someone advise me how to insert more than 1 row a time.
|
| Thanks,
|
| Scott
Scott - 10 May 2008 16:38 GMT
Niek,
Many thanks!
Scott
> Hi Scott,
>
[quoted text clipped - 6 lines]
> |
> | Scott
Shane Devenshire - 11 May 2008 18:22 GMT
Hi Scott,
There is a shortcut key for Insert - Ctrl++ (Ctrl+Plus)
So select any number of rows (or columns or cells) and press Ctrl +.
Cheers,
Shane Devenshire
Microsoft Excel MVP
> Can someone advise me how to insert more than 1 row a time.
>
> Thanks,
>
> Scott