How to Sort a Column with Text from A to Z

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

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 A to Z" 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 A to Z".

Leave a Reply