You can print the following elements: •Selection (specified manually). •Defined area (specified manually or selected automatically if the print area is set in the third-party editor). •Sheet (selected automatically if you did not specify the selection or the set area). 1.Select a cell, a range of cells, rows or columns from which you want to print data. 2.Right-click the selected cells or the titles/contents of the selected rows/columns to open the context menu. 3.Click Print Selection in the context menu. The Page Settings and Print window will open. Print area If you've set a print area in MyOffice Spreadsheet or in the third-party editor, this area will be printed automatically. To set the print area in Microsoft Excel spreadsheet editor, select Page Setup and click Print Area. To set the print area using LibreOffice Calc, select Format > Print ranges. To set a print area in MyOffice Spreadsheet, do as follows: 1.Select the area on the sheet that you want to print. 2.In the Format menu, select Print area and click Define print area. You need to specify the print area for each sheet in the spreadsheet separately.
The borders of the print area are highlighted with a blue frame. If needed, you can hide this frame: 1.In the Format menu, select Print area. 2.Uncheck the Print area borders box. To display the frame, check this box again. To modify the print area (for example, if the selected area is not correct), follow these steps: 1.In the Format menu, select Print area and click Clear print area. 2.Select the area once again as described above. To print the defined area, open the Page Settings and Print window in one of the following ways: •In the File menu, select Page Settings and Print. •Press Ctrl+P. The Page Settings and Print window will open. Print the current sheet 1.Make sure that a print area has not been set for this document. 2.Open the Page Settings and Print window in one of the following ways: •In the Command menu, select File > Page Settings and Print. •On the Toolbar, select the File section and click the arrow to the right of the •Press Ctrl+P. The Page Settings and Print window will open. |
The Page Settings and Print dialog box contains: •Document preview section •Page settings section If the sheet/selected fragment/set area that you want to print is empty or the data reside in hidden rows or columns, the Page Settings and Print dialog box will not open. Instead, the following notification will appear on the screen: “No data to print. Please make sure you have at least one page with data to print”.
The Page Settings and Print dialog box contains the Preview pane. To control the preview, use the following buttons: • •Fit: Set the default page zoom. • Zooming does not affect the print area. The tool is intended for a detailed preview of a document content before printing.
You can resize the Page Settings and Print dialog box by dragging its borders. Print settings The options described in the table below are available within the Page Settings and Print dialog box.
The Page and Print Setup dialog box only contains the settings available for the selected printer.
Click Print to print the document or Cancel to close the window. Page Settings The Page Settings and Print dialog box contains the following page setup options: •Orientation: Select Portrait (vertical) or Landscape (horizontal) page orientation. •Paper Size: Select paper size for printing. •Top Margin, Bottom Margin, Left Margin, Right "f_xo_list_bullet"> Set the distance between the page edges and the contents. You can save the current page setup for further printing. To save the setup and close the window, click Save. To print the document and save the setup, click Print. When printing a selection, the page setup is only applied to the selection and cannot be saved for further printing sessions. |
You can print a document with one click using default settings and without opening additional windows. The following settings are used for Quick Print: •Default print settings. •The last printer used. If you did not use printer before, the default printer in your system is selected. To quickly print the document, follow these steps: •On the Toolbar, select the File section and click •On the Toolbar, select the File section and click the arrow to the right of the |