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.

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

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

Working with large datasets in Excel can sometimes feel overwhelming. Thankfully, Excel makes it easy to hide or unhide rows and columns, allowing you to declutter your spreadsheet and focus on ...

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

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

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

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

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.

How to Give a Name to the Columns in Excel. The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to ...

Learn how to create a Pie Chart in Excel with percentages, without numbers, with words, multiple data or columns, etc. A pie chart helps understand data spread.