Hiding Columns

You can hide (suppress) the columns on a YSL report. A typical example might be a YSL property report, where the property information is positioned across several columns along the top of the worksheet. When you generate the YSL report, if you want the report to show only those property columns that return relevant information, use the Hidecolumn feature to suppress the columns that have no useful data.

On each YSL worksheet, add a Hidecolumn row to determine whether or not a column appears or is hidden.

To hide a YSL report column

1	From the Excel top menu, click File.

2	From the side menu, click Open, then locate and open a YSL report.

3	Enter the word Hidecolumn (with no space between the two words and no quotation marks) in any Column A cell of the worksheet (typically the final row of your template).

Designate only one row as the Hidecolumn row (normally the last row of the YSL report). The Hidecolumn row is always hidden on the final YSL report.

4	For each cell in the Hidecolumn row, enter one of the following cell values:

Cell Value	Result	Description
A non-zero value or a formula that returns a non-zero value	Shows column	If the program returns a non-zero value at run time, the column appears.
0 (zero) or a formula that returns zero	Hides column	If the program returns a zero value at run time, the column is hidden (an empty cell is treated the same as a zero value).
1	Shows column	The column always appears.

An example of a cell value formula might be:

=IF(C$3<>'''',1,0)

This formula means: If the entry in cell C3 (the property sCode at run time) does not equal an empty string, then the value is 1; otherwise, the value is 0.