Insert rows w/o VBA

[lars]

I have 100 rows of data and sometimes many more, can I insert 2 blank rows in between each row other than clicking on each row and without VBA or coding?

[Asala42]

Hiya,

I suppose you could use a sort method.

You said 100 rows? Insert a column and toss in a list of sequential numbers (1 - 100). For example's sake say your in A2 through A101.

Then, starting on A102, use the formula =A2+0.5 (copy down the list to row 202 - you see where this is going, right).

Copy and paste that column as values. Then sort by the new column - now you have a blank row alternating with your data. Then you can optionally delete the inserted column.

Hope that helps,
Adam

[Rocky E]

On 2002-04-30 10:50, lars wrote:
I have 100 rows of data and sometimes many more, can I insert 2 blank rows in between each row other than clicking on each row and without VBA or coding?

Lars,
I guess I am at a loss as to how to answer you question. Even a keyboard macro would actually be VBA. Why no VBA? Without it I see no hope. With there are dozens here that can help you make it work.

_________________
Hope this helps!

Rocky

"Be not the first by whom the New are try'd,
Nor yet the last to lay the Old aside."
ALEXANDER POPE (1688-1744).

[ This Message was edited by: Rocky E on 2002-04-30 11:05 ]

[lars]

Thanks for suggestions, the person doing this doesn't know a thing about VBA and macros so I was trying to come up with a simple solution.

Thanks

[lars]

Arsala, I like that idea very creative is this possible using the same logic to insert two rows instead of one?

That would be interesting

[Asala42]

Sure thing, captain

*Rewind*. Using the example before- Starting at Cell A203, use a formula similar to

=A103+.01 (then copy down through A302). As before, copy paste as values, sort, then delete the extra columnn - now you have 2 rows inserted between every row of data.

Adam