MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using Sort More Effectively


Posted by Harold Kite on March 04, 2001 2:00 PM

I have a spreadsheet that contains Medicare payments and at a later date the Blue Cross payment. This info comes at seperate times. I enter the data as it come in and then do a sort by date and Dr. This gets both payments on two rows next to each other. In order to read the spreadsheet better I put a blank row above and below each completed payment. This works great but I lose the extra row when I do another sort. There is a total of 7 months with 3 or 4 entries per day. Any suggestions appreciated. E-mail to kite@usit.net.


Posted by Tim Francis-Wright on March 05, 2001 10:58 AM


If you want a row after each payment (i.e., data
on every other row), you can get the same effect
by changing the row height for the spreadsheet
to roughly double what it usually is. Then,
you won't have to add extra rows, and the extra
blank rows won't interfere with the sort order.

Hope that helps.