Adding borders, colors, and patterns to cells, Locking row and column titles – Apple AppleWorks 5 : Mac OS User Manual

Page 165

Advertising
background image

Spreadsheet

7-19

Adding borders, colors, and patterns to cells

You can add borders, colors, and patterns to one or more cells, or to entire
rows or columns.

To add a border, color, or pattern, start by selecting the cells, rows, or
columns you want to change. (If you need to use the tool panel, choose
Show Tools from the Window menu.)

Tip AppleWorks comes with preset table styles that you can use to change a
cell’s appearance and formatting in one step. To apply a style or create your
own, see “Using styles” on page 9-5.

Locking row and column titles

To lock row and column titles in a spreadsheet document so they won’t
move as you scroll the rest of the spreadsheet, select the rows or columns
and choose Lock Title Position from the Options menu. Choose it again when
you want to unlock titles.

Note You can’t select cells in locked titles, and you can’t lock titles in a
spreadsheet frame.

*

Choose Index from the

or Help menu and scroll to the entry. Then choose a topic from

the list and click Go To Topic.

To

Do this

Add a border

Choose Borders from the Format menu, select border options, and
then click OK. Or click one of the border buttons on the Default
button bar. Choose a color from the pen color palette on the tool
panel.

Remove a border

Choose Borders from the Format menu, deselect border options, and
then click OK. Or click the border button again.

Change a cell’s border
color

Select a bordered cell and then choose a color from the pen color
palette on the tool panel.

Fill cells with color
or pattern

Click a cell and choose from the fill color and pattern palettes on
the tool panel. Textures and gradients cannot be added to cells.

In the Help index,

*

see:

E

borders, spreadsheet cells

E

spreadsheets, formatting

E

styles

In the Help index,

*

see:

E

locking

Cells in the locked area
have solid borders

This cell was selected when

Lock Title Position was chosen

Advertising