We normally use “helper columns” to do calculations in our Excel worksheet.  These “helper columns” are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss!

But once we are done with presenting our Excel worksheet to our evil boss, we can unhide these Excel columns very easily!

For our example, Columns B and C are hidden:

How to Unhide Columns in Excel | MyExcelOnline

I explain how you can do this below:

YouTube video
How to Unhide Columns in Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Select the columns that is both on the left and right of the hidden columns.

For our example, since our hidden columns are B and C, then we need to highlight columns A (left of B) and D (right of C).

Right-click and select Unhide:

How to Unhide Columns in Excel | MyExcelOnline

 

STEP 2: Your hidden columns are now displayed!

How to Unhide Columns in Excel | MyExcelOnline

 

How to Unhide Columns in Excel

How to Unhide Columns in Excel | MyExcelOnline

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin