Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 145

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 Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a 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