Sorting cell data – Apple AppleWorks 5 : Mac OS User Manual

Page 157

Advertising
background image

Spreadsheet

7-11

Tip AppleWorks comes with preset table styles that you can use to change a
cell’s formatting and appearance in one step. For example, you can apply a
style to format the data, highlight the titles, and apply colors to the rows.
Start by creating a small spreadsheet and entering some data. Then click

on the Default button bar (or choose Show Stylesheet from the Window

menu)

to display the stylesheet. Select rows and columns that you want to highlight
and click 3D Table 1. AppleWorks applies the 3D Table 1 style to the selected
cells. For information on applying styles or creating your own, see “Using
styles” on page 9-5.

Sorting cell data

Sort data in numeric or alphabetical order to organize it. You can specify a major
order key (the cell where the sort starts) and two minor order keys. If you are
sorting a list containing duplicate entries, use second and third order keys to
further organize your data, for example, by first name and middle initial.

To sort spreadsheet data, select the cells you want to sort and click

to sort

in ascending order or click

to sort in descending order. You can also

choose Sort from the Calculate menu. In the Sort dialog box, select the
options you want and click OK.

*

Choose Index from the

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

the list and click Go To Topic.

In the Help index,

*

see:

E

styles

Then click to

apply a style

Properties of the style
3D Table 1

Select the cells

to format

To see a style’s properties, click Edit,
and then select the style

Before

After

In the Help index,

*

see:

E

sorting spreadsheet data

Advertising