Cozmosis
Favorite Answer
Here is a macro that will insert a blank row in between all your rows.
Alt+F11 to open the VB editor
From the VB menu, select Insert\Module
Paste the code below in the VB edit window
Back in Excel, run the macro when you want to insert the blank rows.
---
Sub Insert_Rows()
Dim i As Long
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
For i = ActiveSheet.UsedRange.Rows.Count To 2 Step -1
Rows(i).Insert
Next i
Application.ScreenUpdating = True
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End Sub
tgdaddy
This is a manual, but quick and easy way to do it. Just number your rows with only odd numbers. Then put an equal number of even numbers below your data in blank rows. Then sort and the even numbers, with blank rows, will be in every other row. Here is a more detailed explanation if you need it:
1. Insert a column to the left or right of all your data.
2. In the blank column on the top row, type a 1. In the next row, type a 3.
3. Copy these cells all the way to the bottom of the your data. You should have all your rows numbered with odd numbers (1, 3, 5, 7, etc.). The easiest way to copy them is to select the two cells with the 1 and the 3, and then double click the small square at the bottom right of selection.
4. Once all your rows are numbered, put a 2 in the new column in the row below your data. Put a 4 in the row below that.
5. Copy an equal number of even rows. So if your odd numbered rows went to 785, then you need to copy the even numbers to 786. To copy, select the 2 and the 4. Then click on the little square on the bottom right of the selection and drag it down until you get to the appropriate number of even rows.
6. Select the entire data set, including the blank rows.
7. Sort by the new column. This should put a blank row in between each row.
8. Delete the column you added in step 1.
JG
I am not sure of a quick fix to take care of all of it at once, but if you select the area you want to insert the row into and right click, insert row and select the shift option it will add a row there and more the remainder to where you suggested.
One of the short cuts in excel is the F4 function, if you press this it repeats your last action so you don't have to right click and select insert row each time. Just go to where you need the row and press F4.
VBAXLMan
Here is a free sample file showing you the easiest way to do it
http://www.file1.net/project.asp?id=4R37LxWkkf4H5l
Insert rows using formulas
Since your number of rows between each added row is constant, you can easily apply that function to yours
Enjoy it
VBAXLMan is here to fill your Excel needs
Baccheus
I would use a macro.
Tools - macro - record new macro.
I wonder why you want that though. It's much easier to work with the data without blank rows. If it just for cosmetics, just select all your rows and increase their height.