View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
catlover1946 catlover1946 is offline
external usenet poster
 
Posts: 12
Default find hidden data in worksheet

Biff --what a great idea, and probably the only thing I have overlooked in
searching cells.

"Biff" wrote:

Another trick is using a font size of 1.

Biff

"JLatham" wrote in message
...
Maybe the empty cells aren't really hidden? Perhaps they have text color
set
to background color, making them appear empty unless you select them at
which
time their contents will be revealed.

"catlover1946" wrote:

Excel 2003. Windows XP Professional. Bank reconciliations. How is it
possible in an unprotected worksheet to hide additional data input in
formulas so that visible invalid numbers produce accurate results?
Displaying
hidden formulas in formula bar reveals nothing. Blank cells have been
included in formula, but searches for hidden numbers and links in these
cells
produced nothing. I'm at my wit's end to correct this misuse of Excel in
my
office. Any suggestions?