?
Solved

Accomplish Word Wrap in Text boxes

Posted on 2011-09-20
3
Medium Priority
?
321 Views
Last Modified: 2012-05-12
I have managed to accomplish word wrap in one of the text boxes, but not in the other two.  Assistance is greatly appreciated.
Debt-Reduction.xlsx
0
Comment
Question by:rtod2
3 Comments
 
LVL 24

Expert Comment

by:StephenJR
ID: 36568022
They all look wrapped to me.
0
 

Author Comment

by:rtod2
ID: 36568160
they aren't, the are hard entered
0
 
LVL 12

Accepted Solution

by:
kgerb earned 2000 total points
ID: 36568349
rtod2,
well, I'm not sure if this is what you're looking for but if right click and go to...

Format Shape
Text Box tab
Check Resize shape to fit text

Now go back to the worksheet and resize the box with the drag handles and the text should wrap.  Not sure why but it worked for me.

Kyle
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question