Corel wordperfect office 2002 User Manual
To increase the row height to fit the tallest entry
1 Select a row.
2 Click the Row QuickFit
2 Click the Row QuickFit
button on the toolbar.
You can also double-click the row letter to increase row height.
You can also increase the row height to fit the tallest entry in a selection of cells by
You can also increase the row height to fit the tallest entry in a selection of cells by
selecting a partial row.
To adjust the column width and row height simultaneously
1 Select a cell.
2 Click the Column/row QuickFit
2 Click the Column/row QuickFit
button on the toolbar.
Hiding rows and columns
Quattro Pro lets you hide rows or columns from view on the screen. Hidden rows and columns
do not print. Although they are hidden from view, they are still used in calculations. Columns
move left to fill in the space left by the hidden column, and rows move up; however, row
numbers and column letters do not change. For example, if you hide column B, the columns on
the screen are labeled A, C, D, and so on.
You can reveal rows and columns that are hidden.
You can reveal rows and columns that are hidden.
To hide rows or columns
1 Select the rows or columns to hide.
2 Right-click the rows or columns, and click Hide.
2 Right-click the rows or columns, and click Hide.
To reveal hidden columns
1 Click Edit } Select all.
2 Click Format } Selection properties.
3 Click the Row/column tab.
4 Enable the Reveal option in the Column options area.
2 Click Format } Selection properties.
3 Click the Row/column tab.
4 Enable the Reveal option in the Column options area.
You can also reveal a hidden column by placing the pointer slightly to the right of
where the hidden column should be and dragging.
You can reveal hidden rows by enabling the Reveal option in the Row options area.
You can reveal hidden rows by enabling the Reveal option in the Row options area.
Using formatting tools to format a spreadsheet
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
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
1 Click the cell or cells with the format you want to copy.
2 Click the QuickFormat™
2 Click the QuickFormat™
button on the toolbar.
3 Select the cell or cells where you want to copy the formatting.
Editing and formatting a spreadsheet
201