Table of Contents
Advertisement
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 select Day, Weekday,
Month, or Year in the Fill
Series dalog box, and
entered the date as a label,
Spreadsheet creates
additionalda_s asJabels.
If you entered the date as a
serial number, Spreadsheet
creates additionaldates as
serial numbers; however,
the cell must have a date
format. To filldate
informationas text (suchas
Sunday or January), fillin
5.
the first value as text but do 6.
not abbreviate the month.
For numbers such as a
year value, to fill in a
progressiveseries of years,
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
Advertisement
Table of Contents
