Excel. Have a couple hundred rows filled with data. Is there an easy way to add a blank row between each one?

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

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.

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.

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

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.

Press the CTRL Key and click on the row number of each row you want to delete. And press the Delete key or Right click and select Delete Rows.

I have no idea,but if you add blank rows,you'll have to plant poppies in them. =D