![]() |
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. |
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. |
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. |
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. |
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. |
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 |
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. |
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. |
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. |
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. |
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