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:

I explain how you can do this below:


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:


STEP 2: Your hidden columns are now displayed!


How to Unhide Columns in Excel



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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

How to Correct Spelling in Excel   You have a lot of typos in your spreadsheet, and don't even know where to start... Proofreading is essential, but can be a pain at times! You can correct spelling in Excel very easily! And Excel even goes through the trouble of making spelling suggestions for you! ...
How to Find Duplicates in Excel Normally when we have dirty data, we tend to get a lot of duplicates. But in Excel it is very easy to spot the duplicates for your data cleanup! Here is our sample list of words, you can see it has a lot of duplicates: I explain how you can do this below: DOWNLOAD EX...
How to View Multiple Worksheets in Excel I usually have a workbook that has a lot of worksheets, and I have to view multiple sheets at the same time. Switching tabs back and forth just to compare the contents drives me nuts!! Did you know that you can view multiple worksheets in Excel? Let me show you how! I expla...
How to Group Worksheets in Excel Ever had a time when you needed to modify data across multiple worksheets?  It is very easy to do this using the Group Worksheets feature in Excel! Let us say we have this same mistake on multiple worksheets -  see the Dvv typo in the screenshot below.  We want to change this ...