Tag Archives: Hide

Quick #Excel Tip – Display only the range you want to show on a worksheet…

Posted on April 4, 2024 by MF

by hiding all unwanted columns and rows Did you know there are 16384 columns and 1048576 rows on a worksheet? We have the flexibility to navigate any cells within this large range! Nevertheless, this is NOT what we want some … 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 – #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

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

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