disappearing text

T

Tim

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?
 
G

Gary''s Student

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.
 
F

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.
Click to expand...

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
 
H

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.
Click to expand...

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.
 
D

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.
 
Top