beautypg.com

Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 143

background image

Spreadsheet

7-9

Use the Fill Special command in the Calculation menu to fill cells with:

1

a logical series of numbers, times, or dates

1

a day (Monday), month (January), or quarter name (Qtr 1)

1

any pattern of text or data

For example, you can prepare a schedule by filling a range of cells with times
and another range of cells with the days of the week. To fill a range of cells
with a logical series or a repeated pattern of data, select the cells and then
choose Fill Special from the Calculate menu. Select options and click OK. For a
complete description of the Fill Special command, see onscreen Help.

Formatting cell data

You can change the format of any part of your spreadsheet. Start by selecting
the cell, cell range, column, or row that you want to change.

*

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.

Selected cells

AppleWorks copies the
formula to the selected cells

Result of a formula

Fill Right

Selected cells

AppleWorks fills the
selected cells with data

Fill Special

Cells filled with a

sequence of times

In the Help index,

*

see:

E

spreadsheets

E

spreadsheets, formatting