I first checked to see what text color was used, and converted the entire
worksheet to black type face. All cells have only white background. None
are filled with colored background. Even if text and background color are
the same, the formula should be displayed in the formula bar when the cell is
selected. Since formulas in the formula bar can be hidden, I re-displayed
formula bar contents for the entire workbook.

"JLatham" wrote:

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?