Insert Multiple Rows

C

cleadavis

I have to insert multiple rows, after each existing row, in a vast
spread sheet. Is there some way of specifying that you wish to insert a
certain number of rows (in the same way you can specify spacing between
lines in Word) without having to highlight that number of rows before
each insert? Or, rather, is there an easier way of inserting multiple
rows? Any advice gratefully received.

Thank you,

Clea
 
S

skitown

With out highliting the row
Highlight one cell - then: alt-I-R
After I incert one row.. I hit ctl-Y as many times as I want

ctl-y = repeat.

Ski Town
 
R

Ron de Bruin

Or if you select a whole row use

Ctrl + to insert a row
Ctrl - to delete a row

You can also do this if you select a cell but then you will get a
dialog that asked you what you want to do.
 
Top