Microsoft Office Tutorials and References
In Depth Information
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.
To change the order of the shapes, select the shape in the back, click the Format
contextual tab, and then, in the Arrange group, click Bring Forward. When you do, Excel
moves the back shape in front of the front shape. Clicking Send Backward has the
opposite effect, moving the selected shape one layer back in the order. If you click the
Bring Forward button’s arrow, you can choose to bring a shape all the way to the front
of the order; similarly, by clicking the Send Backward button’s arrow, you can choose
to send a shape to the back of the order.
One other way to work with shapes in Excel is to add mathematical equations to their
interior. As an example, a business analyst might evaluate Consolidated Messenger’s
financial performance using a ratio that can be expressed using an equation. To add an
equation to a shape, click the shape and then, on the Insert tab, in the Symbols group,
click Equation, and then click the Equation Tools Design contextual tab on the ribbon to
display the new interface for editing equations.