Hiding rows or columns in the worksheet

Follow these instructions as part of designing a financial statement.

The Hide Row or Hide Column button on the Financial Statement Designer toolbar is useful if you want to reference certain information in your design, but do not want it to appear on the printed statement. Example

To display revenue per employee in a statement, you manually enter the total number of employees into a cell and hide the cell. In another cell, you create a formula that references the hidden cell. Before producing the statement, you update the employee number in the cell.

Note:

When a hidden row or column intersects with a group of merged cells, any text inside the area where they intersect will not print.

To hide a row or column:

1. Click the row or column of the cell you want to hide.
2. Click (Hide Row) or (Hide Column) on the toolbar.

The hidden row or column is shaded in the worksheet.

To unhide a row or column:

1. Click the row or column you want to unhide.
2. Click (Unhide Row) or (Unhide Column) on the toolbar.

See also

Entering formulas in the worksheet

Right-clicking in the worksheet

Using shortcut keys in the worksheet