Drop-down lists are essential if you need to sort your data or create a pivot table. For example, Excel sees "Texas" and ... Click on the "Data" tab in the top menu so the Data menu ribbon ...
Excel will automatically populate instructions to sort data by Column A from A to Z. 6. Click the "Column" drop-down menu to change to Column B (or another column if you have more than two).
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback