Putting an entire spreadsheet in maturity date order....I can only get the date column to sort righ

[IBBJDS]

I cannot figure out how to do this

[#2]

@IBBJDS 

Make sure that you select the entire range to be sorted, not just the date column.

[#3]

@Hans Vogelaar How do you do that ?

[#4]

@IBBJDS 

Here is an example:

If the data are in a single contiguous range, without empty rows or columns in between the data, it is simple:

• Click in any cell of the date column (in the example above in A1, for example, or A2)
• On the Data tab of the ribbon, in the Sort & Filter group, click the 'Sort A to Z' button:

If there are empty rows and/or columns, as in the screenshot below:

• Use the mouse or the keyboard to select the entire range:
• Use the Tab key to ensure that the active cell in the selected range (the white cell in the selection) is in the date column.
• On the Data tab of the ribbon, in the Sort & Filter group, click the 'Sort A to Z' button, as above.