Microsoft Excel - i have a spreadsheet that is in date order from oldest to current, how can i flip it

How can i flip the whole spreadsheet to go from current date to oldest date.  it is currently going from oldest down to current.  we have a minimum of 52 weeks in these spreadsheets and some are older.  it is standard worksheet with date in first column, then data going across that also has formulas in some cells.
THank you for any help you can give me.

Sorting the entire sheet or area with data based on a header or a colum.  most probably a colum.

select all the data on your sheet you want to sort, then got to Data, Sort, and Sort by this will make sure that the corresponding data in the rows will follow the colum being sorted.




Don

There are a few blank rows (part of the formatting) in the worksheet that will be a problem if I sort and I don't think the date field that I would need to sort on is going to sort in the correct order.   I was thinking maybe index but not sure the formulas will work right.

thank you

Wanda,

you can try it on a test workbook and you will see the blanks will sort to the top based on the colum you chose first.  you can have more than one variable  sort by colum b then by colum a then by colum d..... and so on.

Don