Changing Text Formatting in One Element in Excel 2007:-


In Automatic mode, Excel chooses a font size that is small enough to show the longest text completely. This can cause problems if you have one shape with long text and short text everywhere else. In this case, Excel chooses a small font size for the long text and then forces all the other items to have the same tiny text as well. In such a situation, you might want to override the text size for the shape that has the longest text. Excel then automatically resizes the font size in the remaining automatic shapes to be larger.

The mini toolbar is useful for making these types of changes. You select the text either directly in the shape or in the text pane. Immediately after you complete the selection, you should watch for an almost-transparent formatting box to appear. Then you immediately move the mouse to the box to prevent it from disappearing. You can then change the font size by using the drop-down in the mini toolbar. If you allow the mini toolbar to disappear, you can use the formatting tools on the Home ribbon to change the font size.

In the Figure (given below), the long Level 2 text in step 4 was resized. Excel then calculated the proper text size for steps 1 through 3, resulting in the text in the top three shapes automatically growing to a larger font size.



(When you manually override the font size in the fourth shape, the text in the remaining three shapes automatically becomes larger.)