LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
higgs
 
Posts: n/a
Default Excel keeps wrapping cells with text incl. alt/enter


I have a cell with multiple lines (alt/enter line breaks)
in a standard row where word wrapping is disabled.
So I see only the first line and that's how I want it.

Now, when I edit this cell the word wrapping gets
automatically enabled (checked box) and row height
gets adjusted to fit the text.

It seems alt/enter breaks auto enable the wrapping,
but what I need visible is a clean one line row no matter
what text I put in.

Any solution/workaround? I'm on excel2000.
thanks
--
Peter


--
higgs
------------------------------------------------------------------------
higgs's Profile: http://www.excelforum.com/member.php...o&userid=25994
View this thread: http://www.excelforum.com/showthread...hreadid=393557

 
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
Text Alignment in Excel Cells Eduardo M Excel Discussion (Misc queries) 1 June 23rd 05 08:32 PM
Excel Save As... text with special characters Brynturk Excel Discussion (Misc queries) 2 June 23rd 05 02:59 AM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM
can i get excel to warn me if text appears in 3 different cells steve Excel Worksheet Functions 1 April 17th 05 07:58 PM
Combining & formatting cells with text - Excel 2002 Bob Excel Discussion (Misc queries) 4 March 4th 05 10:35 PM


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