Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Wrapped text disappering in Excel 2003

I'm having a problem with text wrapping in a single cell. When I open up a
new Excel workbook and type in a sentence that goes past the cell width, the
text appears on the screen spanning columns (as you would expect). When I
format the cell and choose the Wrap Text option, the text disappears. When I
highlight that cell the text displays in the formula bar.

Adding an Alt-Enter to the middle or the end of the sentence makes no
difference and changing the Text Alignment makes no difference.

I have sent the file to other co-workers and it (both are 2003 SP2) shows
the text
as expected.

We have reinstalled Office and this problem still occurs.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default Wrapped text disappering in Excel 2003

It sounds like the row needs to be taller to fit the text. Try the Format /
Row / Autofit menu option when the cell is selected and see if that fixes it
for you. (You can also click-and-drag or double-click between the row numbers
to change the row height)

HTH,

TK

"shonnahs" wrote:

I'm having a problem with text wrapping in a single cell. When I open up a
new Excel workbook and type in a sentence that goes past the cell width, the
text appears on the screen spanning columns (as you would expect). When I
format the cell and choose the Wrap Text option, the text disappears. When I
highlight that cell the text displays in the formula bar.

Adding an Alt-Enter to the middle or the end of the sentence makes no
difference and changing the Text Alignment makes no difference.

I have sent the file to other co-workers and it (both are 2003 SP2) shows
the text
as expected.

We have reinstalled Office and this problem still occurs.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Wrapped text disappering in Excel 2003

Tried that -- it's really strange! The cell looks blank, but when you celect
the cell the info is in the staus bar or if you do a print preview you are
able to see it.

Thanks for you help!

Shonnah

"T Kirtley" wrote:

It sounds like the row needs to be taller to fit the text. Try the Format /
Row / Autofit menu option when the cell is selected and see if that fixes it
for you. (You can also click-and-drag or double-click between the row numbers
to change the row height)

HTH,

TK

"shonnahs" wrote:

I'm having a problem with text wrapping in a single cell. When I open up a
new Excel workbook and type in a sentence that goes past the cell width, the
text appears on the screen spanning columns (as you would expect). When I
format the cell and choose the Wrap Text option, the text disappears. When I
highlight that cell the text displays in the formula bar.

Adding an Alt-Enter to the middle or the end of the sentence makes no
difference and changing the Text Alignment makes no difference.

I have sent the file to other co-workers and it (both are 2003 SP2) shows
the text
as expected.

We have reinstalled Office and this problem still occurs.

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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
In Excel formatted wrapped text displays as xxx in cell Linda Excel Discussion (Misc queries) 1 January 26th 06 06:53 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM


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