To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Use the arrows in the Sort dialog box to reorganize your sort criteria in a different order from the one in which you added them. Turn off any filters that hide some of your rows or columns and ...

How to alphabetize columns in Excel 1. Open the Excel spreadsheet you need to alphabetize on your Mac computer or PC. 2. Select the data you want to sort, or do not highlight anything if you wish ...

Finally, move over to Sort By and choose a Column from the list of options. Hit the OK button to complete the task. As we can see, the colored cells in your Excel spreadsheet should have changed.