ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cells blank despite having data in them? (https://www.excelbanter.com/excel-discussion-misc-queries/210160-cells-blank-despite-having-data-them.html)

Misty

cells blank despite having data in them?
 
Does anyone know why cells are appearing as blank despite having data in
them? The data will only be visibile when i select the cells

Thanks in advance,

Charleen

Gunti

cells blank despite having data in them?
 
I could imagine your font format being white. This makes it invisible unless
you select it. No idea if setting your font to black doesn't solve this.

"Misty" wrote:

Does anyone know why cells are appearing as blank despite having data in
them? The data will only be visibile when i select the cells

Thanks in advance,

Charleen


Dave Peterson

cells blank despite having data in them?
 
Is the data visible in the formulabar, but not in the cell?

It could it be a custom format.
It could it be conditional formatting.

Do you use multiple monitors?


Misty wrote:

Does anyone know why cells are appearing as blank despite having data in
them? The data will only be visibile when i select the cells

Thanks in advance,

Charleen


--

Dave Peterson


All times are GMT +1. The time now is 07:04 PM.

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