Filling cells and spreadsheet tabs automatically

Quattro Pro lets you automatically enter repeated labels and functions. Once the initial letters or sequence you are typing is recognized, the data is automatically inserted. As you type a function, the likeliest function displays.

You can fill cells automatically. You can save time by automatically filling cells with a sequence that you start with a seed value. You can also fill spreadsheet tabs automatically.


To insert repeated data automatically

Wordperfect Quattro Pro btnbacktotopproc Filling cells and spreadsheet tabs automatically
1.
 
Click Tools Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically Settings.
2.
 
In the list of categories, double-click Workspaces, Application, and click General.
3.
 
Enable the QuickType check box.
4.
 
Click OK.
5.
 
Type text in a cell.

Wordperfect Quattro Pro note Filling cells and spreadsheet tabs automatically

•
 
The blank cells to be filled must be contiguous with the seed value, extending down the column or across the row to the right.

To fill empty cells automatically

Wordperfect Quattro Pro btnbacktotopproc Filling cells and spreadsheet tabs automatically
1.
 
Select the cells.
2.
 
Click Edit Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically Fill Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically QuickFill.
3.
 
Choose a series from the Series name list box.
4.
 
Choose an element from the Series elements list.
5.
 
In the Fill as area, enable one of the following options:
•
Columns — fills to the bottom of the first column of cells, and continues at the top of the second column
•
Rows — fills to the end of the first row of cells, and continues at the beginning of the second row

Wordperfect Quattro Pro tip Filling cells and spreadsheet tabs automatically

•
 
You can also open the QuickFill dialog box by clicking the QuickFill Wordperfect Quattro Pro pgx btnsfill Filling cells and spreadsheet tabs automatically button on the Notebook toolbar.
•
 
You can create a new series using part of an existing series by modifying the series and saving it under another name.

To fill cells automatically by using seed values

Wordperfect Quattro Pro btnbacktotopproc Filling cells and spreadsheet tabs automatically
1.
 
Type a seed value in a cell.
2.
 
Select the seed value cell and the blank cells you want to fill.
3.
 
Click Edit Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically Fill Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically QuickFill.

Wordperfect Quattro Pro note Filling cells and spreadsheet tabs automatically

•
 
For a list of seed values and resulting sequences, see “QuickFill seed values.”

Wordperfect Quattro Pro tip Filling cells and spreadsheet tabs automatically

•
 
You can also fill cells automatically by clicking the QuickFill Wordperfect Quattro Pro pgx btnsfill Filling cells and spreadsheet tabs automatically button on the Notebook toolbar.

To fill spreadsheet tabs automatically

Wordperfect Quattro Pro btnbacktotopproc Filling cells and spreadsheet tabs automatically
1.
 
Select an empty cell.
2.
 
Click Edit Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically Fill Wordperfect Quattro Pro onestep Filling cells and spreadsheet tabs automatically QuickFill.
3.
 
Choose a list series from the Series name list box.
4.
 
Choose an element from the Series elements list.
5.
 
Enable the Tabs option in the Fill as area.

Wordperfect Quattro Pro tip Filling cells and spreadsheet tabs automatically

•
 
You can also fill cells automatically by clicking the QuickFill Wordperfect Quattro Pro pgx btnsfill Filling cells and spreadsheet tabs automatically button on the Notebook toolbar.

Filling cells and spreadsheet tabs automatically