Microsoft Excel: Add Text To An Autoshape

Article by Mr Excel (11,387 pts ) , published Aug 25, 2008

Problem: Can you add text to any AutoShape?

See all Microsoft Excel tips

Strategy: Some AutoShapes accept text by default. If you have an AutoShape that does not, follow these steps.

1) Right-click the AutoShape and choose Add Text, as shown in Fig. 1362.

2) Click on the AutoShape. Type some text, as shown in Fig. 1363.

Additional Information: To center and then bold the text, follow these steps.

1) The text box is surrounded by diagonal lines. Click on the diagonal lines to change them to dots. Right-click on the dots and choose Format AutoShape, as shown in Fig. 1364.

2) In the Format dialog, go to the Alignment tab. In the Text Alignment section, choose Center for both Horizontal and Vertical. The text will be centered, as shown in Fig. 1365.

3) To make a bolder text, go to font tab, choose a color, 18pt, font, and bold to create the result shown in Fig. 1366.

Summary: You can add text to any AutoShape by using the Right-Click menu to Add Text.

Commands Discussed: Add Text; Format AutoShape

See all Microsoft Excel tips

Images

Fig. 1362Fig. 1363Fig. 1364Fig. 1365Fig. 1366
 
Subscribe to Home Office
RSS
Get free weekly updates, directly to your inbox.