Creating a series to fill cells

You can create a custom QuickFill series, using your own sequences of values and labels, to use with QuickFill. You can modify, rename, or remove a QuickFill series from the series list. Quattro Pro also lets you add elements from a cell to a QuickFill series.

Quattro Pro also lets you specify rules for filling selected cells. You can create your own custom number and formula series. You can also create your own custom date series. To fill dates and times, you must know the date serial number. For more information about date serial numbers, see “Entering values.”


To create a QuickFill formula series

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Select an empty cell.
2.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells QuickFill.
3.
 
Click Create.
4.
 
In the Create/modify series dialog box, type a descriptive name in the Series name box.
5.
 
Enable the Formula option in the Series type area.
6.
 
In the Seed value box, type the first number in the series.
This value is used as a constant in the formula. A string seed value is evaluated as zero.
7.
 
Type a formula in the Formula box.

Wordperfect Quattro Pro tip Creating a series to fill cells

•
 
You can also click Iteration, Seed, and Previous in the Formula definition area to insert the iteration number, seed value, and previous value into the formula. For example, the following formula produces a series that starts with 5 and increases by 5 (5, 10, 15, 20, and so on): #SEED#+(5*#ITER#).
•
 
You can also open the QuickFill dialog box by clicking theQuickFill Wordperfect Quattro Pro pgx btnsfill Creating a series to fill cells button.

To create a QuickFill list series

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Select an empty cell.
2.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells QuickFill.
3.
 
Click Create.
4.
 
In the Create/modify series dialog box, type a descriptive name in the Series name box.
5.
 
Enable the List option in the Series type area.
If you want the series to start again when every element has been entered once, enable the Repeating check box.
6.
 
Type the first element of the list in the Value box.
7.
 
Click Add.
If you want to insert an element before an existing element, highlight the existing element, type the new element in the Value box, and click Insert.

Wordperfect Quattro Pro tip Creating a series to fill cells

•
 
You can also open the QuickFill dialog box by clicking the QuickFill Wordperfect Quattro Pro pgx btnsfill Creating a series to fill cells button.

To modify a QuickFill series

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Select an empty cell.
2.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells QuickFill.
3.
 
Select a series from the Series name list box.
4.
 
Click Modify.
5.
 
In the Create/modify series dialog box, change any series options.

Wordperfect Quattro Pro tip Creating a series to fill cells

•
 
You can also open the QuickFill dialog box by clicking the QuickFill Wordperfect Quattro Pro pgx btnsfill Creating a series to fill cells button on the Notebook toolbar.

To rename a QuickFill series

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells Define QuickFill.
2.
 
Select a series from the Series name list box.
3.
 
Click Rename.
4.
 
In the Rename series dialog box, type the new name in the Series name box.

To delete a QuickFill series

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Select an empty cell.
2.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells QuickFill.
3.
 
Select a series from the Series name list box.
4.
 
Click Delete.

Wordperfect Quattro Pro tip Creating a series to fill cells

•
 
You can also open the QuickFill dialog box by clicking the QuickFill Wordperfect Quattro Pro Creating a series to fill cells l.jpg" height="17" width="17" border="0" hspace="0" vspace="0"> button.

To add elements from a cell to a QuickFill series

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Select an empty cell.
2.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells QuickFill.
3.
 
Click one of the following buttons:
•
Create — adds elements from a list in the notebook to a new series
•
Modify — adds elements from a list in the notebook to an existing series
4.
 
In the Create/modify series dialog box, click Extract.
5.
 
In the Extract values dialog box, specify the cells that contain the new series elements.
If you want to replace any existing elements with those in the notebook enable the Override existing values check box.

Wordperfect Quattro Pro tip Creating a series to fill cells

•
 
You can also open the QuickFill dialog box by clicking the QuickFill Wordperfect Quattro Pro pgx btnsfill Creating a series to fill cells button.

To create a custom series to fill cells

Wordperfect Quattro Pro btnbacktotopproc Creating a series to fill cells
1.
 
Select the cells to fill.
2.
 
Click Edit Wordperfect Quattro Pro onestep Creating a series to fill cells Fill Wordperfect Quattro Pro onestep Creating a series to fill cells Fill series.
3.
 
In the Start box for the first cell, type a value or date or time serial number.
4.
 
Type a step value in the Step box.
5.
 
Type a stop value in the Stop box.
6.
 
In the Order area, enable one of the following options:
•
Column — fills down the columns, starting with the left-most column
•
Row — fills across rows, starting with the top row
7.
 
In the Static area, enable one of the following options:
•
Linear (addition) — adds the step value to the previous value (defined at first to be the start value)
•
Growth (multiplication) — multiplies the step value by the previous value
•
Power (exponentiation) — uses the step value as the exponent of the
previous value
•
Year — increments the series by year
•
Month — increments the series by month
•
Week — increments the series by a 7-day week
•
Weekday — increments the series by week days only
•
Day — increments the series by day
•
Hour — increments the series by hour
•
Minute — increments the series by minute
•
Second — increments the series by second

Wordperfect Quattro Pro note Creating a series to fill cells

•
 
If you select a group of noncontiguous blocks of cells, Quattro Pro fills the cells in the order selected.

Wordperfect Quattro Pro tip Creating a series to fill cells

•
 
If you want the values to decrease, type a negative number in the Start box and type a stop value that is lower than the start value.
•
 
To find the serial number of the date or time you want to start the series, type a date or time in a cell on the spreadsheet using one of the recognized date or time formats, press Enter, click on the cell, and view the serial number in the input line. For more information about date and time serial numbers, see “Entering values.”

Creating a series to fill cells