Forum Discussion
IBBJDS
Apr 01, 2023Copper Contributor
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
HansVogelaar
Apr 01, 2023MVP
Make sure that you select the entire range to be sorted, not just the date column.
IBBJDS
Apr 01, 2023Copper Contributor
HansVogelaar How do you do that ?
- HansVogelaarApr 01, 2023MVP
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.