From: Nick Vivian on
Here's the manual way:
http://excelexperts.com/Excel-Tips-Insert-Alternate-Blank-Lines

Nick
http://excelexperts.com
From: Bob Umlas on
Crooks! :-)
From my book, page 111!
Note on the video: Actually, it's ready to sort without changing the cells
at the bottom to that formula (=cells above +1)
Bob Umlas
Excel MVP

"Nick Vivian" <nick(a)ExcelExperts.com> wrote in message
news:1c83ddbd-7f2a-42cc-b4f1-bff96d9ab54c(a)b9g2000yqd.googlegroups.com...
> Here's the manual way:
> http://excelexperts.com/Excel-Tips-Insert-Alternate-Blank-Lines
>
> Nick
> http://excelexperts.com

From: Michael Styles on
Thanks. Great site I now have bookmarked for reference.

"Nick Vivian" <nick(a)ExcelExperts.com> wrote in message
news:1c83ddbd-7f2a-42cc-b4f1-bff96d9ab54c(a)b9g2000yqd.googlegroups.com...
> Here's the manual way:
> http://excelexperts.com/Excel-Tips-Insert-Alternate-Blank-Lines
>
> Nick
> http://excelexperts.com

From: Zaidy036 on
On 1/26/2010 4:30 PM, Michael Styles wrote:
> I have three Excel 2007 lists, around 200 rows each. I've now found I
> need to insert a blank row after each list entry. Is there any easy way
> to do this? I'm pretty decent with Excel, but don't know VBA. I thought
> of recording a macro, but didn't know how to edit it so that I wouldn't
> have to repeat the same action 200 times for the first list. Can anyone
> help?
>
Free ASAP Utilities has this function.

Eric