insert new rows automatically

N

nic

Hi
I have a big worksheet and need to insert a blank row
after each record, is their a way to do this quickly
rather inserting thousands of rows?
Help appreciated!
Thanks
Nic
 
D

David McRitchie

You could select all cell, and adjust the row height.
Then change your vertical alignment within cells to
top or center.

To insert rows you will need a macro to catch up
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#InsertBlankRows
before considering an event macro for automatic insertion
of rows.

An event macro would be very distracting with all the jumping
around, but also the loss of data when trying to use with
macros that fill in a range of cells would make my event macro
intolerable. Maybe I should not have read the subject
"automatically" since it was not stated that way in the body
of your text.
 
M

Myrna Larson

Assuming a record consists of a single row, and this is a "one time" job, I
would do it this way:

Let's say the last filled row is 5323, and the last used column is M.

Put the number 1 in cell N1. Then use Edit/Fill/Series to fill with
consecutive numbers: Select Series in Columns, Type Linear, Step value 1, Stop
value 5323.

In N5324 put the number 1.5. Again use Edit/Fill/Series: same settings as
above except the stop value is 5323.5

Sort on column N, then clear it.

But if the need for blank rows is purely cosmetic, I would just increase the
row height rather than actually inserting blank rows.
 
Top