How do I detect hidden worksheets or hidden data on a worksheet?

A

Alice

I have a workbook with one worksheet which appears to be empty, however the
saved file is 3.5Mb. I am at a loss as to where all that content is?
 
T

tuph

I am not sure whether worksheets can be hidden, but you should be able
to find hidden rows and columns by clicking on the select all button
(the plain grey button at top left corner of the spreadsheet), then
right click and click on Unhide.

Alternatively, you could look for a break in the row or column sequence
- e.g., A, B, F, G, H or 1, 2, 3, 6, 7, 8.
 
S

starguy

you can see for hidden sheets and unhide them.
go to menu Format > Sheet > unhide
 
D

Dave Peterson

Do you have any pictures/shapes on the worksheet?
Edit|Goto|special|check objects

Open your workbook
hit alt-f11 to get to the VBE
hit ctrl-r to see the project explorer (like windows explorer)
Select your project in that window
hit the asterisk on the numeric keypad to expand everything.

Do you see more than one sheet under Microsoft Objects?

You should see all the sheets and ThisWorkbook.

Debra Dalgleish has some screen prints (for a different purpose), but you may
want to refer to them if you have trouble:

http://www.contextures.com/xlfaqMac.html#NoMacros
 
Top