sorting dates in Excel 97

[Steve T]

Running a worksheet that lists all medical expenses and am not able to
always insert date, expense, who to, in correct sequence. Some postings just
come in on time. Is there a sort formula that will allow me to sort these
entries in sequence? Will the sorting move up the entire row that lists
date, amount, payable to, etc. also? Thank you, Steve T.

 

[Dave Peterson]

I wouldn't use any formulas for this.

I'd select the range (all the columns in that range, plus the last row of
headers, plus all the data) and do Data|Sort

If you include all the columns that should move with the sort, you'll be fine.

But save your file first, then double check it after. If it didn't work ok,
just close without saving and reopen and try again.

 

[Steve T]

Thanks Dave! Data|Sort worked just fine. Steve T

I wouldn't use any formulas for this.

I'd select the range (all the columns in that range, plus the last row of
headers, plus all the data) and do Data|Sort

If you include all the columns that should move with the sort, you'll be
fine.

But save your file first, then double check it after. If it didn't work
ok,
just close without saving and reopen and try again.