Manual

Filling a Range of Cells with Incremental Values
Using Fill Series from the Cell menu, you can automatically fill a range of ceils
with a series of incremental values. Select the range of cells and specify the
starting value and the increment. Spreadsheet does the rest.
If the first cell in a series contains a 1, the next cell will be 2, the following 3,
and so on. If the first cell contains a date, Fill Sedes increments the date;
Monday increments to Tuesday, Wednesday, Thursday, and so on. Time
increments from 1:00 to 2:00, 3:00, and so on.
),To _l a range with incremental values:
1. Enter the value or date you want to increment.
2. Select the range of cells you want to fill, starting with the cell you filled in
containing the value or date you want to increment.
3. Select Fill Series from the Cell menu. A dialog box appears.
4. Fill in the dialog box, specifying the fill options you want:
Fill By. Select whether to fill rows or columns.
ffyou selectDay, Weekday,
Month, or Year in the Fill
Series dalog box, and
entered the date as a label,
Spreadsheet creates
additionalda_s asJabels.
Ifyou entered thedate as a
serialnumber,Spreadsheet
creates additionaldates as
serialnumbers; however,
thecell must have a date
format. Tofilldate
informationas text (suchas
Sunday orJanuary), fillin 5.
the first value as text but do 6.
not abbreviate the month.
For numberssuchas a
year value,to fill ina
progressiveseries ofyears,
enter the year as a label
('1990), not a number. For
"moreinformation,see
Entering and Changing
Dates on page 75.
Units. Select the type of units for the flU: number, day, weekday, month,
or year. _-
Progression. Select the progression you want Spreadsheet to use: Linear
or Geometric. A linear series progresses one step at a time, for example, 1,
2, 3, 4, 5. A geometric series progresses by a specific multiplier at each
step,_for examp!ej i_,_, 9, 27, 81, 243.
Step. For a linear progression of numbers, enter the increment you want
between each value. For a geometric progression of numbers, enter the
multiplier you want to use between each value. For a progression of
dates, enter the number of units (days, weekdays, months, or years) you
want between each value.
Click on Fill. The range is sFdledas you specified.
Click on Close.
Spreadsheet 97