Site icon ExcelNotes

How to Sort Text Column from Z to A

Please follow the steps below to sort a column with text from Z to A, or check sorting a column with text from A to Z.

Step 1: Click any cell in the column you want to sort (e.g., column A);

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort&Filter" in the "Editing" section, and click "Sort Z to A" from the drop-down list;

Step 4: The date column and all other columns are now from A to Z.

Alternatively, please use right-click as below:

Step 1: Right-click the date column and select "Sort" from the list;

Step 2: Select "Sort Z to A".

Exit mobile version