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" wrote in message
...
Here's the manual way:
http://excelexperts.com/Excel-Tips-I...te-Blank-Lines
Nick
http://excelexperts.com