ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why can't I view the contents of a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/71624-why-cant-i-view-contents-cell.html)

MOE26

Why can't I view the contents of a cell?
 
Someone e-mailed a worksheet to me and it appears blank but if I click on a
cell I see the contents in the formula bar above, they just don't appear in
the worksheet itself. Anyone know why?

Elkar

Why can't I view the contents of a cell?
 
Perhaps the text color has been set the same as the background color?

"MOE26" wrote:

Someone e-mailed a worksheet to me and it appears blank but if I click on a
cell I see the contents in the formula bar above, they just don't appear in
the worksheet itself. Anyone know why?


Mike Middleton

Why can't I view the contents of a cell?
 
MOE26 -

Check for (1) text color same as background color or (2) custom format of
three semicolons.

- Mike
www.mikemiddleton.com

"MOE26" wrote in message
...
Someone e-mailed a worksheet to me and it appears blank but if I click on
a
cell I see the contents in the formula bar above, they just don't appear
in
the worksheet itself. Anyone know why?




Dave Peterson

Why can't I view the contents of a cell?
 
And one more...

Maybe it's hidden via Format|conditional formatting.

MOE26 wrote:

Someone e-mailed a worksheet to me and it appears blank but if I click on a
cell I see the contents in the formula bar above, they just don't appear in
the worksheet itself. Anyone know why?


--

Dave Peterson


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com