Pulling AutoShape Text from a Worksheet Cell

AutoShapes are a great way to easily add simple graphics to your worksheets. Better still, AutoShapes are like text boxes, in that they can contain text.

If you know how to add text to a text box, you already know how to add text to an AutoShape. What you may not know how to do is to make that text dynamic, so that it is based on the text stored in a cell of your worksheet. Follow these steps:

1. Select the AutoShape that you want to contain the text. When it is selected (by clicking it once with the mouse), you'll see small selection handles around the exterior of the AutoShape.
2. Click once in the Formula bar.
3. Type and equal sign, and then click on the cell that contains the text you want in the AutoShape.
4. Press Enter.

That's it; the text in the AutoShape is now tied to the text of the cell you specified in step 3. If you change that text, then the text in the AutoShape changes, as well.