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 ...

The Switch Row or Column feature allows you to swap data over the axis. Learn how to switch Rows and Columns in Microsoft Excel.

The header for both the row and column on the spreadsheet will hide, showing cells instead. The other option to hide the row and column headers in Excel is to click the File tab. On the backstage ...

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.

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

Force header columns and rows in Numbers to stay still and visible while you scroll across the rest of the spreadsheet.

By holding down the Ctrl key, you can copy a Word table's row or column to create a new row or column.

Between the 2003 and the most recent versions, the number of rows that can be reached in an Excel sheet has changed significantly. As a result, the VBA codes prevent the portability of your workbook ...