Print selected rows in 1-2-3


Often a spreadsheet contains rows of calculations that nobody needs to see but you. In Excel, you can hide the rows you don't want to print. 1-2-3, however, lets you suppress printing of selected rows without hiding them. If you insert a vertical-bar character (|) into a cell in the first column of a print range, that row will not print. One way to do this is to create a new column to the left of the report, give it a very narrow width, then type a vertical bar into the cells for the rows you don't want printed.

- John Walkenbach


Category:spreadsheet
Issue: November 1999

These Web pages are produced by Australian PC World © 1999 IDG Communications