Hiding and revealing 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.
To hide rows or columns |
1.
|
|
Select the rows or columns to 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.
|
•
|
|
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.
|