Tag Archives: Hide and Seek

Hide and Seek in #Excel – PivotTable Fields

Posted on November 28, 2020 by MF

Have you ever encountered a situation like this? How are we supposed to work with a PivotTable without seeing the data fields? I was so lost when I saw this from a workbook on my friend’s notebook. He came to … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – Scroll Bars and Worksheet Tabs in #Excel

Posted on July 18, 2020 by MF

Did you encounter this?  All the worksheet tabs and scroll bars are gone in your Excel workbook!!! 🎶🎶 Tell me… how am I supposed to work without you…🎶🎶   No worries!  They are not gone.  They are just hidden (by … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Hide and Seek – Formula Bar, Column and Row Headers

Posted on July 11, 2020 by MF

Have you ever experienced a shocking moment like this in #Excel? We are so getting used to see the formula bar, Column and Row headers that we take it for granted.  They should always be there for me…. aren’t they? … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment

VBA to make selected sheets “Very Hidden” in #Excel

Posted on April 26, 2018 by MF

VBA to make selected sheets “Very Hidden”;  all sheets visible Weeks ago, I showed the way to unhide a very hidden sheet in #Excel via Visual Basic editor (VBE).  You may refer to that post HERE.  Technically we could follow … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

Hide and Seek – External Links in #Excel

Posted on April 12, 2018 by MF

The haunted External Links that won’t go away… Have you ever bothered by this never-go-away warning message? You’d searched all worksheets (visible or hidden and very hidden too) in order to locate the external links and remove them.  Somehow, you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Hide and Seek – #Excel Worksheet

Posted on April 5, 2018 by MF

How to unhide a very hidden worksheet? Situation: You see in the formula bar that the cell is referred to a worksheet called “VeryHidden”.  However you don’t see it on the sheet tab. Naturally you right-click on a sheet tab … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 3 Comments

April #Excel Fool

Posted on April 1, 2018 by MF

Wanna have fun with your colleagues who get too serious in #Excel on April Fool?  How about playing Hide and Seek? You may refer to my blog posts below for some ideas: Hide and Seek – #Excel Workbook Hide and … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Hide and Seek – #Excel Workbook

Posted on March 29, 2018 by MF

Have you ever had this experience with #Excel?  Someone sent you a workbook that is empty!  What I mean empty here is not that there is no content in the workbook.  You know that there are lots of data in … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 1 Comment

Hide and Seek – Cell Content

Posted on March 22, 2018 by MF

Don’t be shy!  Let silly things continue!  Let’s Hide and Seek with #Excel again! 🙂 Case 1 Case 2 Case 3 You may download a Sample File – Hide and Seek Cell Content for the above cases. If you know the … Continue reading →

Rate this:

Posted in Format | Tagged , , , , , | 1 Comment

Hide and Seek – Column A

Posted on March 15, 2018 by MF

Cannot unhide column A? I know… it sounds another silly thing in #Excel.  But I do believe many novice users have had this experience before.  If you were one of them, you would know how frustrating that would be.  I … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , | 4 Comments

Hide and Seek – Cell border

Posted on March 8, 2018 by MF

Making cell border in #Excel should be something really basic.  However, some people may have found it frustrating/confusing to play Hide and Seek with borders just hoping that they will be displayed in the way they want it. For example, … Continue reading →

Rate this:

Posted in Format | Tagged , | Leave a comment

When unhide row doesn’t work…

Posted on April 1, 2014 by MF

This above video was made just recently.  You may read this post to understand more.  Note: Please turn on CC for English subtitles. Hidden rows cannot be unhidden? Why? Although today is April Fools’ Day and the question sounds like … Continue reading →

Rate this:

Posted in Excel Basic, Excel Tips | Tagged , , | 165 Comments