Hidden text in cell ???

Lars Kentill

unread,

Feb 12, 2007, 7:54:00 AM2/12/07

to

I can see cell text in the status bar - but text in the actual cell is not
visable? Does anyone have a clue why.

Bob Phillips

unread,

Feb 12, 2007, 8:01:47 AM2/12/07

to

Conditional formatting hiding it? The font colour is white?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Lars Kentill" <LarsK...@discussions.microsoft.com> wrote in message
news:026917A4-F9E3-460F...@microsoft.com...

Gary''s Student

unread,

Feb 12, 2007, 8:01:01 AM2/12/07

to

There are several things to check:

1. make sure the identation is not pushing the text out of view
2. make sure text wrapping is not consistent with the cell dimensions
3. make sure the color of the text is not the same as the background color.
--
Gary''s Student
gsnu200705

Lars Kentill

unread,

Feb 12, 2007, 8:04:00 AM2/12/07

to

Hi Carl,
Thanks for the tip - but nope - allready tried that without success.....

Yours,
Lars

"Carl" skrev:

> Font colour white / cell colour white?
>
> Change the font colour to black?

>
>
> "Lars Kentill" <LarsK...@discussions.microsoft.com> wrote in message
> news:026917A4-F9E3-460F...@microsoft.com...

Dave Peterson

unread,

Feb 12, 2007, 8:10:24 AM2/12/07

to

One more...
The cell has a custom format of
;;;

Lars Kentill wrote:
>
> I can see cell text in the status bar - but text in the actual cell is not
> visable? Does anyone have a clue why.

--

Dave Peterson

Lars Kentill

unread,

Feb 12, 2007, 8:17:01 AM2/12/07

to

Hi all,
Thanks for your inputs. I found the problem - it was related to standard
typography.

Cheers, Lars

"Bob Phillips" skrev:

Brian

unread,

Apr 17, 2007, 4:14:01 PM4/17/07

to

Lars,
Issues:
1) When I open an existing spreadsheet (expense report not a template) that
has text in rows. The text shows up in the status bar but isn't visable in
the cell. If you go into the cell, the text is there.
2) All the rows were compressed to very small.
3) When it prints, all the text is on the page.

I installed Excel 2003 SP2 - Standard Edition for Teachers and Students.
Have it on 2 pc's. The most recent PC is where the issue shows up. If I open
the same file on my other PC it is fine.

All answers to your previous thread aply. Font color is black. No unusal
fonts etc.

Any ideas?

Gord Dibben

unread,

Apr 17, 2007, 4:39:03 PM4/17/07

to

If you can see cell contents in the Formula Bar(not Status Bar) perhpas you have
the cells Custom Formatted to ;;; (that's 3 semi-colons).

Gord Dibben MS Excel MVP

On Tue, 17 Apr 2007 13:14:01 -0700, Brian <Br...@discussions.microsoft.com>
wrote:

Brian

unread,

Apr 17, 2007, 4:56:04 PM4/17/07

to

Gord-
thanks but the field is formatted to Arial 6pt. No custom format.

Dave Peterson

unread,

Apr 17, 2007, 7:33:11 PM4/17/07

to

Do you use multiple monitors?

http://groups.google.co.uk/group/microsoft.public.excel.misc/browse_frm/thread/46fd5b60d11761fd/7109488256478b2d?lnk=st&q=wrap+text+display+group%3A*excel*&rnum=16#7109488256478b2d

or

http://snipurl.com/1crbf

Mike Brambley posts a link to a suggestion that worked for him.

--

Dave Peterson