Microsoft Office Tutorials and References
In Depth Information
Creating shapes and mathematical equations
TIP Holding down the Shift key while you draw a shape keeps the shape’s proportions
constant. For example, clicking the Rectangle tool and then holding down the Shift key
while you draw the shape causes you to draw a square.
You can resize a shape by clicking the shape and then dragging one of the resizing handles
around the edge of the shape. You can drag a handle on a side of the shape to drag that
side to a new position; when you drag a handle on the corner of the shape, you affect
height and width simultaneously. If you hold down the Shift key while you drag a shape’s
corner, Excel keeps the shape’s height and width in proportion. To rotate a shape, select the
shape and then drag the white rotation handle at the top of the selection outline in a circle
until the shape is in the orientation you want.
TIP You can assign your shape a specific height and width by clicking the shape and then,
on the Format tool tab, in the Size group, entering the values you want in the height and
After you create a shape, you can use the controls on the Format tool tab to change its
formatting. To apply a predefined style, click the More button in the lower-right corner of
the Shape Styles group’s gallery and then click the style you want to apply. If none of the
predefined styles are exactly what you want, you can use the Shape Fill, Shape Outline, and
Shape Effects options to change those aspects of the shape’s appearance.
TIP When you point to a formatting option, such as a style or option displayed in the Shape
Fill, Shape Outline, or Shape Effects lists, Excel displays a live preview of how your shape
would appear if you applied that formatting option. You can preview as many options as
you like before committing to a change. If a live preview doesn’t appear, click the File tab to
display the Backstage view and then click Options to open the Excel Options dialog box. On
the General page, select the Enable Live Preview check box and click OK.