From: Nick Vivian on 27 Jan 2010 04:27 Here's the manual way: http://excelexperts.com/Excel-Tips-Insert-Alternate-Blank-Lines Nick http://excelexperts.com
From: Bob Umlas on 27 Jan 2010 10:14 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 30 Jan 2010 10:46 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 30 Jan 2010 15:28 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
First
|
Prev
|
Pages: 1 2 Prev: Is it possible to count the no. of characters in a cell in Excel? Next: countif with time |