Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
What about right mouse - format text - alignment - wrap text?
HTH Tonto |
#4
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Excel Text Import Wizard | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Where is text to speech in excel 2003? | Excel Discussion (Misc queries) |