Microsoft Office Tutorials and References
In Depth Information
Creating shapes and mathematical equations
If you want to use a shape as a label or header in a worksheet, you can add text to the
shape’s interior. To do so, select the shape and begin typing; when you’re done adding text,
click outside the shape to deselect it. You can edit a shape’s text by moving the pointer
over the text. When the pointer is in position for you to edit the text, it will change from a
white pointer with a four-pointed arrow to a black I-bar. You can then click the text to start
editing it. If you want to change the text’s appearance, you can use the commands on the
Home tab or on the Mini Toolbar that appears when you select the text.
You can move a shape within your worksheet by dragging it to a new position. If your
worksheet contains multiple shapes, you can align and distribute them within the worksheet.
Horizontal shape alignment means that the shapes are lined up by their top edge, bottom
edge, or center. Vertical shape alignment means that they have the same right edge, left
edge, or center. To align a series of shapes, hold down the Ctrl key and click the shapes you
want to align. Then, on the Format tool tab, in the Arrange group, click Align, and then click
the alignment option you want.
Distributing shapes moves the shapes so they have a consistent horizontal or vertical
distance between them. To do so, select three or more shapes on a worksheet, click the
Format tool tab and then, in the Arrange group, click Align and then click either Distribute
Horizontally or Distribute Vertically.
If you have multiple shapes on a worksheet, you will find that Excel arranges them from
front to back, placing newer shapes in front of older shapes.