Setting a Print Range

By default, Calc prints all sheets containing data in a spreadsheet document. You can designate a specific group of cells as the only cells in the spreadsheet that will print. This feature is useful when you want to print an individual sheet or select parts of a spreadsheet rather than the whole document.

1. Select the cells you want to include in the print range.

2. Choose Format > Print Ranges > Define.

To add cells to the already defined print range, select the new cells and choose Format > Print Ranges > Add. You can also add cells to the print range by choosing Format > Print Ranges > Edit, and entering the cell references in the Print Area field.

To remove a print range so that the entire spreadsheet is available for printing, choose Format > Print Ranges > Remove.