Tag Archives: Unhide

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 – #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

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

When unhide row doesn’t work…

Hidden rows cannot be unhidden? Why? Although today is April Fools’ Day and the question sounds like an April Fool’s question, this post is not about to fool anyone.  Just another real case to share. For an unprotected sheet, hidden … Continue reading

Rate this:

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