disappearing text

[Guest]

I have cells of text in a spreadsheet that disappear any time I apply a font
formatting change (e.g., select a character and change to bold). The text is
still there. I can see it in the formula bar when I click on the cell. It
is visible in print preview and in printouts, but invisible on the monitor.
Very frustrating! Any suggestions?

 

[Guest]

There are three ways to make a cell's content appear to vanish:

1. make the color of the font the same as the background color
2. indent the cell contents out of the visible range
3. applying a protection that hides the cell contents

Make sure that you are not doing any of these.

 

[Franz Verga]

Nel post *Gary''s Student* ha scritto:

There are three ways to make a cell's content appear to vanish:

1. make the color of the font the same as the background color
2. indent the cell contents out of the visible range
3. applying a protection that hides the cell contents

Make sure that you are not doing any of these.

There is also a fourth possibility. The cell is formatted with Custom format
with this string of formats ";;;" (no quote).

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Ciao

Franz Verga from Italy

 

[Harlan Grove]

Gary''s Student wrote...

There are three ways to make a cell's content appear to vanish:

1. make the color of the font the same as the background color
2. indent the cell contents out of the visible range
3. applying a protection that hides the cell contents

Make sure that you are not doing any of these.

There are 3 other possibilities.

4. the number format is ";;;"
5. a drawn object covers the cell, e.g., a pasted picture link of a
blank cell
6. hardware and/or driver failure/flakiness

Of these, only cell text color could change due to conditional
formatting. OP should also check for CF.

 

[Dave Peterson]

One more thing to check...

Try widening the column or increasing the row height.

Just a guess that the increase in width (from the change in boldness) is causing
the text to wrap at an unusual spot--maybe moving things down a bit and out of
sight.

 

[Gord Dibben]

Tim

Just a guess here but maybe you are a victim of the "high contrast" problem.

It speaks of "color" but maybe Bold is included in that category.

See this KB article.

http://support.microsoft.com/kb/833258/en-us


Gord Dibben MS Excel MVP