Adding Text to a Shape

Most people know that you can add textboxes to your worksheet, but don't realize that you can actually add text to any of the shapes Excel allows you to add. Just follow these steps:

1. Add your shape as you normally would. (Insert tab of the ribbon, Shapes tool.)
2. Right-click the new shape. Excel displays a Context menu.
3. Choose Edit Text from the Context menu. An insertion point appears within the body of the AutoShape.
4. Type your desired text.
5. Click somewhere outside the boundaries of the shape, such as within a cell of the worksheet.

If you later resize your shape, then the text within it is reformatted to fit the new dimensions of the shape. (This behavior is the same that occurs if you resize a textbox that contains text.)