Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erik
 
Posts: n/a
Default wrapped text does not display

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default wrapped text does not display

Sometimes, adding alt-enters every 80-100 characters will help.

If the cell is merged, then you may have to adjust the rowheight manually.



Erik wrote:

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Erik
 
Posts: n/a
Default wrapped text does not display

Thank you, Dave, but the problem exists no matter how many or few characters
are in the cell, and for both merged and unmerged cells.

"Dave Peterson" wrote:

Sometimes, adding alt-enters every 80-100 characters will help.

If the cell is merged, then you may have to adjust the rowheight manually.



Erik wrote:

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin Vaughn
 
Posts: n/a
Default wrapped text does not display

Have you played with the row height? I've had similar experiences and if I
make the row height a little smaller (normally) I can see the data.
--
Kevin Vaughn


"Erik" wrote:

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik

  #5   Report Post  
Posted to microsoft.public.excel.misc
Erik
 
Posts: n/a
Default wrapped text does not display

Thank you, Kevin. However, I tried the row height and it doesn't change
anything.

"Kevin Vaughn" wrote:

Have you played with the row height? I've had similar experiences and if I
make the row height a little smaller (normally) I can see the data.
--
Kevin Vaughn


"Erik" wrote:

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik



  #6   Report Post  
Posted to microsoft.public.excel.misc
Erik
 
Posts: n/a
Default wrapped text does not display

My wrapped text is displaying again. Although the exact problem was not
identified, our IT department just replaced my port replicator, which I use
to connect my laptop to our firm's network. The wrapped text now appears
normally.

"Erik" wrote:

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik

  #7   Report Post  
Posted to microsoft.public.excel.misc
Kevin Vaughn
 
Posts: n/a
Default wrapped text does not display

That was going to be my next guess.

j/k

--
Kevin Vaughn


"Erik" wrote:

My wrapped text is displaying again. Although the exact problem was not
identified, our IT department just replaced my port replicator, which I use
to connect my laptop to our firm's network. The wrapped text now appears
normally.

"Erik" wrote:

I've seen other posts on the web with similar problems as mine, but I haven't
found a solution:

When a cell in Excel is formatted to wrap text, the text does not display.
It will print, it shows up on print preview, and it will show up if I edit
the cell, but it does not display when I'm simply looking at the spreadsheet.
I've checked the font color, alignment, number format, but none of these
make a difference.

Any ideas? Thank you, Erik

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
How can I get a long block of wrapped text to print? DianeWms Excel Discussion (Misc queries) 3 February 8th 06 03:30 PM
How to adjust spacing between lines of wrapped text ? SUZL Excel Discussion (Misc queries) 1 December 15th 05 10:51 PM
Cells formated as text do not always display properly Cass Excel Discussion (Misc queries) 2 July 23rd 05 01:59 AM
How do I make rows expand to fit wrapped text in cells? FRUSTRATED Excel Discussion (Misc queries) 2 May 27th 05 06:31 PM
in excel how to display results of a function and text in the sam. ez123 Excel Worksheet Functions 3 November 19th 04 01:16 PM


All times are GMT +1. The time now is 09:42 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"