Page 583 - Excel 2013 All-in-One For Dummies

To do this, open the Format Shape dialog box while the text box is selected by right-clicking the text box and then choosing Format Shape from its short- cut menu. Then, click the Text Box tab and enter the new values (in fractions of an inch) that you want to use in the Top, Bottom, Left, and Right text boxes in the Internal Margin section. Also, select the Resize Shape to Fit Text check box in the AutoFit section to put a check mark in it if you want Excel to auto- matically resize the text box to suit any formatting changes you make to its text (such as increasing the font size, adding bold, or selecting a new text alignment).
Editing the text in a text box
You can edit the text in a text box as you would in any cell of the worksheet. To insert new text, click the insertion point at the appropriate place and start typing. To delete text, press the Backspace key to delete characters
to the left of the insertion point or the Delete key to delete characters to
its right. To delete an entire section of text, select it with the I-beam mouse pointer and then press the Delete key.
To spell check some or all of the text in the text box, select the text by dragging the I-beam mouse or Touch pointer through it and then click the Spelling button on the Review tab of the Ribbon (or just press F7).
To delete a text box from the worksheet, click its border to select the box (indicated by the solid as opposed to dotted outline) and then press the Delete key. Be sure that you don’t click inside the box because this selects only the text (indicated by the dotted outline), in which case, pressing the Delete key doesn’t get rid of anything but characters of text at the cursor’s position.
Adding an arrow to a text box
When creating a text box, you may want to add an arrow to point directly to another graphic object or to the part of an embedded chart to which you’re referencing. To add an arrow, follow these steps:
1. Click the text box to which you want to attach the arrow in the chart or worksheet to select it.
Sizing handles appear around the text box, and the Format tab on the Drawing Tools contextual tab is selected on the Ribbon.
2. Click the Arrow command button in the Insert Shapes drop-down gallery at the very beginning of the Format tab.
The Arrow command button is the second from the left in the Lines section of Shapes gallery (with the picture of an arrow). When you click this button, it becomes selected in the gallery palette (indicated by the
Drawing Graphics 565
Book V Chapter 2
Adding Graphic Objects