N Niek Otten May 10, 2008 #2 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 | 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 | Can someone advise me how to insert more than 1 row a time. | | Thanks, | | Scott
S Shane Devenshire May 11, 2008 #4 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
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