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

Why Grouping Is Better Than Hiding Before I show you how to create column groups in Excel, let me explain the many benefits of using this method over hiding and unhiding columns.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...

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.

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

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.

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.