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

We show you how to rearrange columns in Excel using four different techniques. Each will ensure that your data will not be overwritten.

We show you how to put data in alphabetical order in Excel, sorting columns, rows, and using handy shortcuts.

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.

The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...