You can use the drawing toolbar to add special shapes,
such as eclipses, diamonds, and triangles, to highlight cells.
Microsoft® Excel
2003
To add a special shape for a cell, do the following
steps:
- If the drawing toolbar is not displayed,
click .
- On the drawing toolbar, click to select a shape.
The cursor becomes a cross.
- Drag the cursor to draw the selected shape, and then drag the
shape to a suitable size.
- Right-click the shape and click Format AutoShape.
The Format AutoShape window opens.
- Click the Colors and Lines tab in the Format
AutoShapes window. In the Fill field, set Color to No
Fill to make the shape transparent.
- Click the Properties tab. Select Move
and size with cells to make the shape size change with
the cell size.
- Click OK.
IBM® Lotus Symphony Spreadsheets
To
add a special shape for a cell, do the following steps:
- If the drawing toolbar is not displayed,
click .
- On the drawing toolbar, click to select a shape. The
cursor becomes a cross.
- Drag the cursor to draw a shape, and then drag the shape to a
suitable size.
- Select the shape and open the Properties panel on the sidebar.
In the Area section, set Fill and Transparency fields
to None.
In Lotus® Symphony™ Spreadsheets,
the shape size changes with the cell size automatically.