Tuesday, April 9, 2019

To hide any tab in Microsoft Excel...

...just right-click on the tab and pick "Hide" while right-clicking on any one other tab while a tab is hidden will allow for "Unhide..." to be in the little menu that right-clicking brings us. Excel won't let you hide every tab. Why hide tabs at all? The hidden stuff can serve as a backing store for data if you are making a complicated application in Excel. I guess you may reach in there with calculations. There is a way to lock the hidden in a hidden state that I don't understand and I won't bother looking into, but as an Excel architect you may do this before you hand your Excel masterpiece on to others so that the others don't think too hard about what you've given them.

No comments:

Post a Comment