Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column([reference]).

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.

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

Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

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

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.

Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.

Learn Excel 365 calculated columns to enhance your data analysis skills with dynamic formulas, cross-table calculations for real-time insight ...

Excel Online supports sorting by multiple columns. How to sort by two columns Grouping is a common database task, and sorting by multiple columns is essentially the same thing.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.