Using formatting tools

Quattro Pro lets you format a spreadsheet by copying the formatting (background color, font, numeric format, and so on) of one cell to another cell or selection of cells.

You can apply a predesigned format to data. You can also add a format to the predesigned format list. This formatting overrides any existing cell property settings.


To copy cell formatting

Wordperfect Quattro Pro btnbacktotopproc Using formatting tools
1.
 
Click the cell or cells with the format you want to copy.
2.
 
Click the QuickFormat Wordperfect Quattro Pro pgx quickf Using formatting tools button on the toolbar.
3.
 
Select the cell or cells where you want to copy the formatting.

Wordperfect Quattro Pro tip Using formatting tools

•
 
To turn off QuickFormat, click the QuickFormat Wordperfect Quattro Pro pgx quickf Using formatting tools button on the toolbar.

To apply a predesigned format

Wordperfect Quattro Pro btnbacktotopproc Using formatting tools
1.
 
Select the cells to format.
2.
 
Click Format Wordperfect Quattro Pro onestep Using formatting tools SpeedFormat.
3.
 
Choose a format from the Formats list.

Wordperfect Quattro Pro tip Using formatting tools

•
 
You can also apply a predesigned format by clicking the SpeedFormat Wordperfect Quattro Pro pgx speedfmt Using formatting tools button on the toolbar.
•
 
You can revise a predesigned format by disabling any properties that you do not want applied to the cells.

To add a format to the predesigned format list

Wordperfect Quattro Pro btnbacktotopproc Using formatting tools
1.
 
Click Format Wordperfect Quattro Pro onestep Using formatting tools SpeedFormat.
2.
 
Choose a format to customize from the Formats list.
3.
 
Click Add.
4.
 
Type the name of the new format in the Format name box.
5.
 
Select the cells that contain the format using the Range picker Wordperfect Quattro Pro pgx btnpoint Using formatting tools tool in the Example cells box.

Using formatting tools