See all Microsoft Excel tips
Strategy: Use AutoShapes. If the Drawing toolbar is not displayed, use View – Toolbars – Drawing. The Drawing toolbar is typically docked to the bottom of the worksheet, as shown in Fig. 1334.
1) The Drawing toolbar itself offers five standard shapes – Line, Arrow, Rectangle, Oval, and Textbox. Choose the Oval tool in the toolbar, as shown in Fig. 1335.
2) Left-click in the worksheet and drag to draw an oval, as shown in Fig. 1336. You can drag down or right to make the ellipse more portrait or landscape.
As shown in Fig. 1337, by default, the AutoShape is filled with white and covers up text.
3) Use the dropdown next to the paint bucket in the Drawing toolbar. Select No Fill from the list, as shown in Fig. 1338.
4) Use the LineStyle icon and choose a thicker line, perhaps 3 point, as shown in Fig. 1339.
Result: As shown in Fig. 1340, you’ve added an attention-grabbing shape to the worksheet. This will draw the reader’s eye to the conclusion.
Summary: Use the Drawing toolbar to select an AutoShape and insert it into your worksheet.
Commands Discussed: Drawing toolbar
See all Microsoft Excel tips
