Can someone advise me how to insert more than 1 row a time.

Thanks,

Scott

Hi Scott,

If you select 5 rows and then hit the Insert>Sheet Rows button, Excel will insert 5 rows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Scott" <NoSpam-Scott.Xe@GMail.com> wrote in message news:eXG51FrsIHA.5068@TK2MSFTNGP02.phx.gbl...
| Can someone advise me how to insert more than 1 row a time.
|
| Thanks,
|
| Scott

Niek,

Many thanks!

Scott

"Niek Otten" <nicolaus@xs4all.nl> ¦b¶l¥ó
news:OADLLIrsIHA.3680@TK2MSFTNGP05.phx.gbl ¤¤¼¶¼g...
> Hi Scott,
>
> If you select 5 rows and then hit the Insert>Sheet Rows button, Excel will
> insert 5 rows
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Scott" <NoSpam-Scott.Xe@GMail.com> wrote in message
> news:eXG51FrsIHA.5068@TK2MSFTNGP02.phx.gbl...
> | Can someone advise me how to insert more than 1 row a time.
> |
> | Thanks,
> |
> | Scott
>
>

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

"Scott" <NoSpam-Scott.Xe@GMail.com> wrote in message
news:eXG51FrsIHA.5068@TK2MSFTNGP02.phx.gbl...
> Can someone advise me how to insert more than 1 row a time.
>
> Thanks,
>
> Scott