ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting multiple rows (https://www.excelbanter.com/excel-discussion-misc-queries/65045-inserting-multiple-rows.html)

syssupspe

Inserting multiple rows
 
Hi,
I woould like to insert about 6 rows to the bottom of my spreadsheet. Is
there an easier way to do this besides inserting one at a time. Thanks.

Pete

Inserting multiple rows
 
If you want to insert 6 rows between row 10 and 11, say, select the row
identifier for row 11 then drag down until 6 rows are highlighted. Then
simply Insert | Rows.

Hope this helps - you can do the same thing for columns.

Pete


Michael

Inserting multiple rows
 
Select six rows first, then go to insert row. That will insert 6 rows all at
once. HTH
--
Sincerely, Michael Colvin


"syssupspe" wrote:

Hi,
I woould like to insert about 6 rows to the bottom of my spreadsheet. Is
there an easier way to do this besides inserting one at a time. Thanks.


syssupspe

Inserting multiple rows
 
Thanks, I knew it had to be pretty easy,just never inserted more than one row
at a time before. thanks again.

"Pete" wrote:

If you want to insert 6 rows between row 10 and 11, say, select the row
identifier for row 11 then drag down until 6 rows are highlighted. Then
simply Insert | Rows.

Hope this helps - you can do the same thing for columns.

Pete




All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com