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 Lock Cells in Excel Have you encountered a scenario where you do not want to lock the whole sheet, but just a couple of cells in your Excel worksheet?Locking an entire sheet is straightforward, but locking separate cells is a different story.Let us say, we have this single cell that we want ...
CTRL + BACKSPACE: Go Back to the Active Cell Say that you click in cell A4 within your Excel worksheet and then you scroll all the way down to the bottom of the page to check on a number in row 20,187.The quickest way to get back to your active cell in A4 is to press the CTRL + BACKSPACE on your keyboard!Watch below...
Smart Lookup in Excel 2016  There were times when I was working in a spreadsheet and I had to do a quick internet search to understand some of the words in my cells.The process was, copy the text, paste on my browser, and click search.Little did I know that in Excel 2016, there is a featur...
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 ...