Tag Archives: Hide and Seek

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

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

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

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

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

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

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

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

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

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

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…

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 , , | 154 Comments