Using Print Ranges

While we will work some strategies for keeping important information together on a particular printed page, you can choose to print key areas of a spreadsheet using a print range. A print range is simply a range of selected cells that will then be printed. Specifying print ranges allows you to select exactly what information will be sent to the printer. This is especially useful in cases where you have a very large spreadsheet but only need a hard copy of certain key information in a particular range.

To Create a Print Range

You can quickly create a print range in the current sheet.

1.
Select the range that you want to specify as a print range.
2.
Select the Format menu, point at Print Range, and then select Create. A border ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.