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’.


img43
img44
img45
img46
img47
img48
img49
img50
img51
img52
img53
img54
img55
img56
img57
img58
img59
img60
img61
img62
img63
img64
img65
img66
img67
img68
img69


Print 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.

Print copies

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.

Print Chart