Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Why does the text go out of randge in my Text Box (from controll t

Hi all,
I created a text box by going to view-tool bar-control box. Then I selected
Text box. So that I could insert a paragraph of about 391 characters (with
space). My text box is 510 wide and 85 high.
The paragraph simply went out of range. I can only read the first 10 words!
I selected wrap text from the properties window but the texts are not
wrapping.
What am I doing wrong?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Why does the text go out of randge in my Text Box (from controll t

Set the MultiLine property to True.

--
Jim
"checkQ" wrote in message
...
Hi all,
I created a text box by going to view-tool bar-control box. Then I
selected
Text box. So that I could insert a paragraph of about 391 characters (with
space). My text box is 510 wide and 85 high.
The paragraph simply went out of range. I can only read the first 10
words!
I selected wrap text from the properties window but the texts are not
wrapping.
What am I doing wrong?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Why does the text go out of randge in my Text Box (from contro

Gee thanks Jim. It worked like a charm!

"Jim Rech" wrote:

Set the MultiLine property to True.

--
Jim
"checkQ" wrote in message
...
Hi all,
I created a text box by going to view-tool bar-control box. Then I
selected
Text box. So that I could insert a paragraph of about 391 characters (with
space). My text box is 510 wide and 85 high.
The paragraph simply went out of range. I can only read the first 10
words!
I selected wrap text from the properties window but the texts are not
wrapping.
What am I doing wrong?




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
Text does not display in "Text boxs" and when wrapping text in a c Esteban Excel Discussion (Misc queries) 1 March 8th 07 11:59 PM
How to increase font size in drop-down controll Iver Excel Discussion (Misc queries) 2 January 30th 06 02:03 PM
text (3750 char.)truncates with text wrap and row heigh adjusted? Boydster Excel Discussion (Misc queries) 1 May 19th 05 05:59 PM
convert a range of lowercase text to upper text or vice versa jackdaw Excel Worksheet Functions 2 May 16th 05 09:31 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM


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