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

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.

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

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.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

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

In Microsoft Excel, you can permanently hide columns containing data you don't need to have on show. However, grouping columns is often a better way to achieve the same outcome, especially if you ...

How to Join Two Columns in Excel. When you're setting up a Microsoft Excel spreadsheet to build an employee directory, calculate product margins or project sales, you may run into circumstances in ...

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

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.

Converting a table of data with multiple columns into a single column in Microsoft Word can be done in several ways. You can use the INDEX or OFFSET macro commands to create a function that ...