Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
Inserting rows in multiple workbooks | Excel Discussion (Misc queries) | |||
Sort with multiple header rows | Excel Discussion (Misc queries) | |||
Multiple rows converted to one row | Excel Worksheet Functions | |||
Convert multiple columns to rows | Excel Worksheet Functions |