Microsoft Office Tutorials and References
In Depth Information
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
mouse pointer over the text. When the mouse 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. Aligning shapes horizontally means arranging them so they are lined up by their
top edge, bottom edge, or center. Aligning them vertically means 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 contextual 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 contextual tab and then, in the Arrange group, click Align and then click either
Distribute Horizontally or Distribute Vertically.