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

How to sort a single column in Excel without disrupting the rest of the spreadsheet Your email has been sent We tend to view spreadsheet data as a whole, and that’s as it should be. Seldom does ...

Launch Excel and open the spreadsheet that contains the list that you want to sort. Click to select a range of data, such as A1 through A20, or click the header to select the entire column of data.

Stay tuned Excel supports a second custom support: sorting by multiple columns. In a future article, I’ll show you how to use this same feature to sort by multiple columns.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.