Saturday, March 16, 2013

How to Sort Columns by Date in Excel


1. Click on the columns you would like to sort. For example, if you want to sort column A, click on the 'A' column header to highlight the entire column.
2. Click on the 'Data' tab, then click on 'Sort.' This will open the sort dialog box.
3. Click on the 'Continue With the Current Selection' radio button, then click on 'Sort.'
4. Click on the arrow underneath 'Order' and select either 'Newest to Oldest' or 'Oldest to Newest' depending on which way you want to sort the dates.
5. Make sure the 'Sort on' selection box reads 'Values,' then click on 'OK.' Excel will sort the column according to date.

Blogger news