Open your Microsoft Excel spreadsheet. To rearrange the order of the columns, select the the column header and click and hold the dark vertical line.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Q. I often recruit Excel to do double duty as a database, and there are times I’d like to reverse the order of numbers or names in a table. How can I do that? A. In other words, you want to take a ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...