ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hidden text in cell ??? (https://www.excelbanter.com/excel-discussion-misc-queries/130299-hidden-text-cell.html)

Lars Kentill

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

Carl

Hidden text in cell ???
 
Font colour white / cell colour white?

Change the font colour to black?


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



Gary''s Student

Hidden text in cell ???
 
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" 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.


Bob Phillips

Hidden text in cell ???
 
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" wrote in message
...
I can see cell text in the status bar - but text in the actual cell is not
visable? Does anyone have a clue why.




Lars Kentill

Hidden text in cell ???
 
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" wrote in message
...
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

Hidden text in cell ???
 
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

Hidden text in cell ???
 
Hi all,
Thanks for your inputs. I found the problem - it was related to standard
typography.

Cheers, Lars

"Bob Phillips" skrev:

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" wrote in message
...
I can see cell text in the status bar - but text in the actual cell is not
visable? Does anyone have a clue why.





Brian

Hidden text in cell ???
 
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?

"Lars Kentill" wrote:

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

Cheers, Lars

"Bob Phillips" skrev:

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" wrote in message
...
I can see cell text in the status bar - but text in the actual cell is not
visable? Does anyone have a clue why.





Gord Dibben

Hidden text in cell ???
 
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
wrote:

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?

"Lars Kentill" wrote:

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

Cheers, Lars

"Bob Phillips" skrev:

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" wrote in message
...
I can see cell text in the status bar - but text in the actual cell is not
visable? Does anyone have a clue why.





Brian

Hidden text in cell ???
 
Gord-
thanks but the field is formatted to Arial 6pt. No custom format.

"Gord Dibben" wrote:

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
wrote:

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?

"Lars Kentill" wrote:

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

Cheers, Lars

"Bob Phillips" skrev:

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" wrote in message
...
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

Hidden text in cell ???
 
Do you use multiple monitors?

http://groups.google.co.uk/group/mic...09488256478b2d

or

http://snipurl.com/1crbf

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

Brian wrote:

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?

"Lars Kentill" wrote:

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

Cheers, Lars

"Bob Phillips" skrev:

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" wrote in message
...
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


All times are GMT +1. The time now is 10:31 PM.

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