Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
4407mark
 
Posts: n/a
Default How can I wrap text in a text box in Excel?

I'm creating a form in Excel with fields to be completed by the user. In
three sections, I need to insert a text box and have the entered text wrap to
the next line within the designated box. I have tried merging the cells
"under" the textbox and clicking on "wrap text" but it still does not want to
wrap.
  #2   Report Post  
Matthew S
 
Posts: n/a
Default How can I wrap text in a text box in Excel?

I'm not sure if I understand your question. I hope I'm not over simplifying.

If you have a Text Box and you want the text within the box to wrap, select
the box and make it narrower by dragging in one of the sides. Otherwise, if
you dont want to change the size of the Text Box, place the cursor in the
text string where you want it to wrap (end the line) and hit enter.

"4407mark" wrote:

I'm creating a form in Excel with fields to be completed by the user. In
three sections, I need to insert a text box and have the entered text wrap to
the next line within the designated box. I have tried merging the cells
"under" the textbox and clicking on "wrap text" but it still does not want to
wrap.

  #3   Report Post  
Tonto
 
Posts: n/a
Default How can I wrap text in a text box in Excel?

What about right mouse - format text - alignment - wrap text?

HTH

Tonto

  #4   Report Post  
wirthless
 
Posts: n/a
Default How can I wrap text in a text box in Excel?


Hi - I am a new user, but have just been playing with this as well.
Don't worry about merging cells. Just select whatever cells you want
and make sure Text Wrap is selected. Also make sure your cells are big
enough to display the information. I have not discovered a convenient
way to jump down a space within the same cell so you could enter, say,
all address inormation in one cell (return or tab exits the cell).
This can be accomplished by entering that information in empty cells
elsewhere and cutting and pasting them - not into the cell itself, but
into the entry bar on the toolbar. I hope this helps. - Tom


--
wirthless
------------------------------------------------------------------------
wirthless's Profile: http://www.excelforum.com/member.php...o&userid=28423
View this thread: http://www.excelforum.com/showthread...hreadid=480252

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
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Access Excel Linked Text and Number Issues Scott Excel Discussion (Misc queries) 2 October 4th 05 09:24 PM
Excel Text Import Wizard [email protected] Excel Discussion (Misc queries) 2 September 12th 05 12:00 AM
Why doesn't text wrap in a cell in Excel? rohrbaught Excel Discussion (Misc queries) 6 April 8th 05 06:13 PM
Where is text to speech in excel 2003? BogieJr Excel Discussion (Misc queries) 2 March 26th 05 08:04 PM


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