Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

Text boxes in Excel 2010 are graphical boxes that you can use to add explanatory text or commentary to a worksheet or chart. Text boxes can be positioned wherever you like and can be formatted to match the chart or worksheet data that they accompany.

Inserting a text box

Follow these steps to insert a text box in a chart or worksheet:

  1. On the Insert tab, click the Text Box button in the Text group.

    The mouse pointer looks like an upside-down cross.

  2. Click and drag diagonally on the worksheet (or in a chart) to draw the box the size you want.

    A blinking cursor appears inside the text box.

  3. Type the desired text.

    The text wraps when you reach the right side of the box. Press Enter as you type if you want to begin a new line.

    Use a text box in Excel 2010 to annotate data in a chart or worksheet.
    Use a text box in Excel 2010 to annotate data in a chart or worksheet.
  4. Click outside the text box to deselect it.

    The selection handles disappear and the text box contains the typed text.

Editing a text box

You can make several types of editing changes to a text box you've added to the worksheet:

  • If you just need to edit the text inside a text box, click inside the text box and change the text as needed. Use the commands in the Font group on the Home tab to edit the font properties.

  • Drag any selection handle to resize the text box.

  • Drag the text box border (between the selection handles) to move the text box.

  • Click the text box border and press the Delete key to delete the text box.

Formatting a text box

When you insert a text box in Excel 2010, it looks very plain. You can format text boxes to make them stand out on the worksheet. Follow these steps to format an existing text box in an Excel 2010 worksheet:

  1. Right-click the text box and choose Format Shape.

    The Format Shape dialog box opens. In this dialog box, choose any of these formatting options:

    • To add a background fill to the text box, click Fill in the left pane and select an option from the right side of the dialog box.

    • To change the border color that surrounds the text box, click Line Color and choose a line color option.

    • To change the style of the line surrounding the text box, click Line Style and choose any desired options.

    • To add a shadow around the text box, click Shadow and then choose an option from the Presets drop-down list.

    • Make the text box three-dimensional with choices on the 3-D Format and 3-D Rotation tabs.

    • From the Text Box tab, select Resize Shape to Fit Text. As you add or remove text from the text box, the box expands or contracts to fit around the text.

  2. Click Close when you're done.

    The text box displays the applied formatting.

    Format a text box to add emphasis.
    Format a text box to add emphasis.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: