Insert Question

[spilparc]

Hi, when I use the insert feature to insert more rows in my
spreadsheet, I can only do one row at a time. Is there a way to
insert, say 5, or 10 rows at a time?

Thanks

 

[Anne Troy]

First select 5 or 10 rows, then use the insert. It will insert as many rows
as you select.
************
Anne Troy
www.OfficeArticles.com

 

[Peo Sjoblom]

Select 5 rows, then insert

Regards,

Peo Sjoblom

 

[spilparc]

First select 5 or 10 rows, then use the insert. It will insert as many rows
as you select.
************
Anne Troy
www.OfficeArticles.com

Hi, the only problem with doing it this way is that there is something
else in the way. I'm trying to insert rows in the middle of my
spreadsheet where there is already data above and below. Any other
suggestions?

Thanks.

 

[Dave Peterson]

You can still select rows and insert more rows, even if there is existing data
in those rows.

Are you trying to keep the formulas from the row above?

If yes, you could use a macro by David McRitchie:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm