Preview a worksheet

To preview a worksheet, click on ‘File’ from the main menu bar and from the resulting drop-down menu, click on ‘Print Preview’. This will open the preview display of the worksheet as has been shown below. To close the preview, click on ‘Close Preview’.

Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.

To print a worksheet, click on ‘File’ from the main menu bar and from the resulting menu, click on ‘Print’. This will open the ‘Print’ dialog box. In this dialog, under the ‘General’ tab, we have certain options under ‘Range and Copies’.

To print only a selected cell range from the worksheet, select the required cells before opening the ‘Print’ dialog box and then in the dialog box, select the ‘Selected cells’ radio button under ‘Range and Copies’. After this, click on ‘OK’. This will print only the selected cells.

To print a worksheet, simply select the ‘Selected sheets’ radio button under ‘Range and Copies’ and click on ‘OK’. This will print only the current worksheet.

To print multiple copies of a worksheet, select the value of copies to be required under ‘Number of copies’ and then click on ‘OK’. This will print the required number of copies.

To print the entire spreadsheet, select ‘All sheets’ under ‘Range and Copies’ and then click on ‘OK’. This will print the entire spreadsheet.

To enable the printing of charts, click on ‘Format’ from the main menu bar, and from the resulting drop-down click on ‘Page’. This will open the ‘Page Style’ dialog box. Here, under the ‘Sheet’ tab, we have a section called ‘Print’. Under this section we have a ‘Charts’ checkbox. Check this box to enable the printing of charts and uncheck to disable it. This is how we can control the printing of charts in Calc.