Brother International PDP350CJ Owner's Manual - English - Page 174

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. If you select Day, Weekday, Month, or Year 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. 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. Spreadsheet 160