Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

How to Unhide Columns in Excel

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

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:

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:

 

STEP 2: Your hidden columns are now displayed!

 

How to Unhide Columns in Excel

 

HELPFUL RESOURCE:

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 c...
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...
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 brows...
Add the Calculator to the Excel Toolbar There were times when I had to find my Calculator App while I was doing some quick calculations in Excel. Instead of scrambling for the Calculator Application, you can actually have this inside of ...
Searching... Searching...

DO YOU WANT TO GET BETTER AT EXCEL?
If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!

Click here to subscribe

Leave a Comment

Your email address will never be published. Required fields are marked with *

Comments