Brother Ensemble PDP-100J, Owner'S Manual

Page: 174 / 440

Spreadsheet 160
Filling a Range of Cells with Incremental Values
Using the Fill Series choice on the Cell menu, you can automatically fill a
range of cells with a series of incremental values. You 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 Series 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 fill 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. Choose 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.
Units. Select the type of units for the fill: 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 example, 1, 3, 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.
5. Click on Fill. The range is filled as you specified.
6. Click on Close to close the dialog box.
If you select Day, Weekday, Month,
or Y
ear in the Fill Series dialog box,
Spreadsheet creates the series
differently depending on how you
originally entered the date. If you
entered the date as a label,
Spreadsheet creates additional
dates as labels.
If you entered the date as a series
number, Spreadsheet creates
additional dates as serial numbers;
however, the cell must have a date
format. To fill date information as
text (such as “Sunday” or “January”),
fill in the first value as text. For
numbers such as a year value, to fill
in a progressive series of years,
enter the year as a text value
(“1990), not a number
. For more
information, see “Entering and
Changing Dates” on page
147.