Hiding columns or rows

Hiding columns or rows

Areas of the table may be hidden from view by selecting the columns or rows you wish to hide, then right-clicking and selecting the hide selected column(s) or hide selected row(s) option.

Hidden areas are not charted or exported, so you can use this technique to build custom charts, or paste data into specific areas of an Excel report.

Helpful Hint:
If you want to chart several different variables on a reduced set of columns or rows, you will find it faster to create a new variable containing only those codes you are interested in (rather than continually hiding the unrequired columns).