How to Edit and Format Text Boxes in Excel 2007 - dummies

How to Edit and Format Text Boxes in Excel 2007

By Diane Koers

When you insert a text box in Excel 2007, it can look quite plain. You can format text boxes to make them stand out on the worksheet. Use the options on the Format Shape dialog box to dress them up with special formatting commands.

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

Follow these steps to format an existing text box in an Excel 2007 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 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 select an option from the Presets drop-down list.

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

    • From the Text Box option, 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.