In case you want to alphabetize data in several columns, use the Excel Sort command, which gives more control over how your data is sorted.Īs an example, let's add one more column to our dataset, and then arrange the entries alphabetically first by Region, and then by Name:
Mac outlook error ok gimap ready for requests from 50.4.178.209 d12 v6mb168467006ivf how to#
How to put multiple columns in alphabetical order To remove the filter, simply click the Filter button again. To reverse the order, select Sort Z to A from the filter drop-down menu. The column is alphabetized straight away, and a small upward arrow on the filter button indicates the sorting order (ascending): Click the drop-down arrow for the column you want to put in alphabetical order, and select Sort A to Z: Small drop-down arrows will appear in each of the column headers.
This tutorial will teach you a few quick and easy ways to put Excel in alphabetical order.