Rick,
If you only want to do it for display spacing purposes, simply select all
the cells, then change the row height to twice its current value.
Inserting blank rows is usually a bad idea....but if you still want to do
it, an easy manual way is to insert a new column A. In cell A1 enter a 1,
and enter a 2 in cell A2. Select A1:A2 and double click the fill handle to
fill down to row 1500 (assuming the current column A doesn't have blank
cells). Copy all those cells in column A (with 1 to 1500), and paste them
at the bottom of column A. Sort your entire sheet ascending on column A.
Delete column A and you're done.
HTH,
Bernie
MS Excel MVP
