The Sort dialog box will show up with the first sorting level created for you automatically as Excel sees fit.On the Data tab, in the Sort & Filter group, click the Sort button.In most cases, you can select just one cell and Excel will pick the rest of your data automatically, but this is an error-prone approach, especially when there are some gaps (blank cells) within your data. Select the entire table you want to sort.To have it done, please perform the following steps: 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: 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.On the Home tab, in the Editing group, click Sort and Filter > Filter.The beauty of this method is that it's one-time setup - once the auto filter is applied, the sort options for all columns are only a mouse click away. Filter and alphabetize in ExcelĪnother quick way to sort alphabetically in Excel is to add a filter. Excel table has inbuilt sorting and filtering options. Technically, all our examples are for ranges. In this tutorial, a "table" is just any data set. Problems with alphabetical sort in Excel.Sort alphabetically by multiple columns.Sort alphabetically and keep rows intact.Fastest way to alphabetize column in Excel.This tutorial will show you a few quick ways to alphabetize in Excel and teach how to foresee and prevent sorting problems. In some situations, however, the built-in features may stumble, but you can still figure out a way to sort by alphabetical order with formulas. Whether you are sorting an entire worksheet or selected range, vertically (a column) or horizontally (a row), ascending (A to Z) or descending (Z to A), in most cases the task can be accomplished with a button click. It also provides solutions for non-trivial tasks, for example how to alphabetize by last name when the entries start with the first name.Īlphabetizing in Excel is as easy as ABC. This tutorial will teach you a few quick and easy ways to put Excel in alphabetical order.
0 Comments
Leave a Reply. |