What experts don’t tell you about hidden worksheets (revealed)


October 27th, 2005 by admin admin

Did you managed to find the content hidden in Sheet2?

If you have not, here’s how. Enter the formula “=Sheet2!A1″ in Sheet1. Copy and paste the formula in the range “A1:M20″. You should be able to see text “BINGO. YOU HAVE MANAGED TO FIND THIS WORKSHEET.” in Cell C5.

To make it nicer, you can go to Tool, Options and click on the view tab. Click off the check box on zero value. (See diagram). The zeros all disppear showing the text on Sheet1 clearly.

So how did I make sheet2 disappear such that it will not even show up using the Format, Sheet, unhide approach? Find out tomorrow.

Leave a Reply

You must be logged in to post a comment.

s2Member®