Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default 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.



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 683
Default 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.




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.




  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 683
Default 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.





  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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.



  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy from a Cell to a text box. AJL Excel Worksheet Functions 9 November 7th 06 04:58 PM
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? PaulH_1980 Excel Worksheet Functions 1 March 15th 06 11:51 PM
Cell Capacity - text i2meek Excel Discussion (Misc queries) 4 March 13th 06 12:06 AM
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
Help inserting a Cell Value in a Text Cell Dave Excel Worksheet Functions 5 March 5th 05 09:06 PM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"