Resizing rows and columns
Quattro Pro lets you change the row height in a spreadsheet. You can also change the width of a column.
Quattro Pro uses a default column width for all columns in a spreadsheet. This default width of an active spreadsheet is wide enough to display nine characters in the default font. You can change the default width of an active spreadsheet.
Values that are wider than the cell display either in scientific notation or as a row of asterisks (*********), depending on the numeric format and width of the cell. You can automatically increase the column width as you type so that number values are always visible.
Columns whose widths you explicitly adjust are not controlled by the default width of the active spreadsheet. Before those columns can be affected by a change in the default width of the active spreadsheet, you must reset the column width of the active cell. You can also return row heights to the active cell default size, which is determined by the largest font used in the row.
Resizing rows and columns to fit a specific cell
To accommodate long entries, Quattro Pro lets you increase the column width to one character wider than the longest entry in a selection. You can also increase the row height to fit the tallest entry in a selection.
You can adjust the row height and column width at the same time.
To change the row height |  |
|
1.
|
|
Select a cell in each row you want to resize, or select the row borders.
|
|
2.
|
|
Click Format
 Selection properties. |
|
3.
|
|
Click the Row/column tab.
|
|
4.
|
|
In the Row options area, enable the Set height option and type a value in the box.
|
|
5.
|
|
Enable one of the following options:
|
|
•
|
Points
|
|
•
|
Inches
|
|
•
|
Centimeters
|
|
•
|
|
You can also change row height by moving the pointer to the bottom edge of a row border until it changes to a double arrow,
 and dragging the double arrow to resize the row. |
|
•
|
|
You can select noncontiguous rows by pressing Ctrl before selecting the rows.
|
To change the column width | |
|
1.
|
|
Select a cell in each column you want to resize, or select the column borders.
|
|
2.
|
|
Click Format
Selection properties. |
|
3.
|
|
Click the Row/column tab.
|
|
4.
|
|
In the Column options area, enable the Set width option and type a value in the box.
|
|
5.
|
|
Enable one of the following options:
|
|
•
|
Characters
|
|
•
|
Inches
|
|
•
|
Centimeters
|
|
•
|
|
You can also change column width by moving the pointer to the right edge of a column border until it changes to a double arrow,
and dragging the double arrow to resize the column. |
|
•
|
|
You can select noncontiguous columns by pressing Ctrl before selecting the columns.
|
To change the default column width of the active spreadsheet | |
|
1.
|
|
Click Format
Sheet properties. |
|
2.
|
|
Click the Default width tab.
|
|
3.
|
|
Type a value in the Column width box.
|
|
4.
|
|
In the Unit area, enable one of the following options:
|
|
•
|
Characters
|
|
•
|
Inches
|
|
•
|
Centimeters
|
|
•
|
|
You can also change the default column width by right-clicking a spreadsheet tab and clicking Sheet properties.
|
To increase the column width for numeric values as you type | |
|
1.
|
|
Click Tools
Settings. |
|
2.
|
|
In the list of categories, double-click Workspaces, Application, and click General.
|
|
3.
|
|
Enable the Fit As-You-Go check box.
|
|
•
|
|
The Fit As-You-Go feature applies only when using the Number, Currency or Percent numeric format.
|
To restore the default column width of the active cell | |
|
1.
|
|
Select a cell in each column whose width you want to restore to default.
|
|
2.
|
|
Click Format
Selection properties. |
|
3.
|
|
Click the Row/column tab.
|
|
4.
|
|
Enable the Reset width option.
|
|
•
|
&nbs
p; |
Click the Property
 button to access the Row/column tab. |
|
•
|
|
You can select noncontiguous columns by pressing Ctrl before selecting the columns.
|
To restore the default row height of the active cell | |
|
1.
|
|
Select a cell in each row whose height you want to restore to default.
|
|
2.
|
|
Click Format
Selection properties. |
|
3.
|
|
Click the Row/column tab.
|
|
4.
|
|
Enable the Reset height option.
|
|
•
|
|
Click the Property
button to access the Row/column tab. |
|
•
|
|
You can select noncontiguous rows by pressing Ctrl before selecting the rows.
|
To increase the column width to fit the longest entry | |
|
1.
|
|
Select a column.
|
|
2.
|
|
Click the Column QuickFit
 button on the toolbar. |
|
•
|
|
You can also increase the column width to fit the longest entry by clicking Format
QuickFit Column QuickFit. |
|
•
|
|
You can also double-click the column letter to increase column width.
|
|
•
|
|
You can also increase the column width to fit the longest entry in a selection of cells by selecting a partial column.
|
To increase the row height to fit the tallest entry | |
|
1.
|
|
Select a row.
|
|
2.
|
|
Click the Row QuickFit
 button on the toolbar. |
|
•
|
|
You can also increase the row height to fit the tallest entry by clicking Format QuickFit
Row QuickFit. |
|
•
|
|
You can also double-click the row letter to increas
e row height. |
|
•
|
|
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
button on the toolbar. |
|
•
|
|
You can also adjust the column width and row height simultaneously by clicking Format
QuickFit Column/Row QuickFit. |