Forum Discussion

IBBJDS's avatar
IBBJDS
Copper Contributor
Apr 01, 2023

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

I cannot figure out how to do this

3 Replies

      • 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.

Resources