
In addition, Calc normally suppresses notes that you've attached to cells but will print those notes along with the rest of the spreadsheet if you click to select the Notes option. Normally, the gridlines that separate cells are suppressed during printing, but to help with your row and column alignment when studying large spreadsheets, you may opt to select the Grid option so that Calc prints the gridlines to paper.

The Sheet page specifies how you want your spreadsheet to print. For example, if you want to print formulas instead of the values they equate to, you would click to select the Formulas option in the Print area of the Sheet page. The Sheet tab displays the Sheet page, where you can specify the kinds of items you wish to print or to suppress during printing. The Format, Page menu option displays the Page Style dialog box. The preview ensures that your printed spreadsheet will look exactly the way you want it to look before you send the spreadsheet to paper. If the lines separating each label are not displayed, click the Layout tab and select the View Gridlines option in the Table pane.

Before printing, be sure to view a preview with File, Page Preview. Click on print preview in the opened window above your document select Format Page select the Sheet tab in the middle of the new window in the print section, select Grid.
