Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Find Hidden Cells On Worksheet. On the Home tab in the Cells group click Format Visibility Hide Unhide Hide Sheet. One click to display all hidden sheets and another click to hide them again.
Thats the window you saw after clicking View Code in the above screencast. Youll be presented with a dialog box listing which sheets are hidden so select the ones you want to unhide. If you want to see just one or two hidden sheets heres how you can quickly unhide them.
Click the tab of the first worksheet to be hidden to select it.
One click to display all hidden sheets and another click to hide them again. 2 Click the Choose Format From Cells button and then select the hidden cell that you found out or formatted in Step 1 and click the OK button to. Alternatively you can also press F5 and then Alt S to open the Go to Special dialog. You can find a named range by going to the Home tab clicking Find Select and then Go To.
