View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tuph tuph is offline
external usenet poster
 
Posts: 1
Default How do I detect hidden worksheets or hidden data on a worksheet?


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.


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=569271