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

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.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.