Microsoft Excel sorting by date

Question

I am having a terrible time sorting data by date.&nbsp; I have attached a sample along with how each column is formatted.&nbsp; Please Help.Yok33

riny_van_eekelen · Answer

Yok33&nbsp;There is no sample attached. Please try again.

yok33 · Answer

Riny_van_Eekelen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

Yok33&nbsp;
The problem is that by default, Excel treats the yellow row as header row instead of the green row.
As a workaround, select the range that you want to sort: D6:G17 (or D7:G17).
Use the Tab key to select a cell in the date column, then sort.

riny_van_eekelen · Answer

Yok33&nbsp;Alternatively, insert a blank row between the yellow and the green. Select E8 and then Sort to end-up with this:&nbsp;

Forum Discussion

Microsoft Excel sorting by date

4 Replies

Resources