• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Adding Text Outside a Cell

Most of the text you type in a worksheet is contained in individual cells. However, Excel does enable you to add text outside the cells in separate text boxes. This capability is useful for adding text to charts or adding notes to worksheets. And, because the text in a text box is independent of the cells, you can place a text box anywhere on a worksheet or chart. To create a text box, follow these steps:

1.
Display the area on the worksheet or chart where you want the text box placed.

2.
If the Drawing toolbar is not displayed, right-click any toolbar or Excel’s menu bar and click Drawing. The Drawing toolbar appears.

3.
Click the Text Box button. When you move the mouse pointer over the worksheet area, it appears as a crosshair pointer.

4.
Position the pointer where you want one corner of the text box to appear, and then drag the pointer to the opposite corner to define the box size and dimensions. Excel inserts the text box, as shown in Figure 9.9.

Figure 9.9. Excel inserts the text box.


5.
Type your text in the text box, and use the Formatting toolbar to style the text. As with WordArt, the text box is surrounded by handles you can drag to change the size or dimensions of the box. Drag the box’s border to move it.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint