Print with presets

The Page setup and print window contains:

• Document preview area
• Print settings area

If the sheet, selected fragment or specified area does not contain print data or all print data is in hidden columns and rows, the Page setup and print window does not open. A dialog box is displayed with the message: “No data to print. Please make sure you have at least one page with data to print.”

The document preview area contains the following buttons:

• and : Zoom in or out the page in the preview area.
• Fit to window: Fit the page into the preview area.
• and : Go to the next/previous page of the document.

The zoom set in the preview area does not affect the print borders. The zoom tools are intended only for detailed viewing of the document content.

For convenient view, you can expand the Page setup and print dialog box to the desired size by changing its borders.

In the print settings area, you can set the options listed in the table below.

Option	About
Printer settings
Printer	Select a printer to print the document.
Printer properties	This option is only available in Windows. Clicking opens the printer properties dialog box. The type and contents of the dialog box options depend on the printer model selected in the box above. The settings specified in the Printer properties dialog box are automatically transferred to the appropriate boxes in the Page setup and print dialog box.
Print in grayscale	Print the color text and images contained in the document in grayscale.
Page setup
Copies	The number of copies of the document to be printed.
Collated / Uncollated	Collated: Pages are grouped by the copies (1,2,3 1,2,3 1,2,3). Uncollated: Pages are grouped by the number of the pages (1,1,1 2,2,2 3,3,3).
Print area	Defined area: Printing of the defined area of the document. Entire sheet: Printing of the sheet that is currently displayed on the screen. Selection: Printing of the fragment selected in the document.
Range	All pages: Printing of all pages of the current sheet or defined print area. Odd pages only , Even pages only: These options are for manual double-sided printing of a document on a printer that does not support this type of printing in automatic mode. To print, you need to select odd-numbered pages first, then turn the stack of sheets backwards and select to print even-numbered pages.
Box for entering page numbers/ranges for printing	Individual page numbers. For example, 5, 10, 12. Page ranges separated by the hyphen. For example, 1-8, 10-11. Pages from the beginning of the sheet, area, fragment to the specified one in the -<No.> format. For example, if you type -3 , pages 1-3 will be printed. Pages from the specified one to the end of the sheet, area, or fragment in the <No.>- format. For example, if you type 3- in the box and the sheet, area, or fragment has 6 pages, pages 3-6 will be printed.
Duplex printing	None: Print on only one side of the page. Long-edge binding: Print on both sides of a sheet of paper where paper flips along the long edge. Short-edge binding: Print on both sides of a sheet of paper where paper flips along the short edge.
Page orientation	Portrait (vertical) or Landscape (horizontal) page orientation.
Paper size	The standard size of the paper used for printing.
Ignore blank pages	Pages that do not contain data cells, objects (charts, images, shapes), or cells with borders or fill are considered blank. The option is selected by default. When you select/clear the Ignore blank pages checkbox, blank pages are hidden or displayed in the preview area and the total number of pages decreases or increases. If you want to print individual pages or page range of the selected sheet, area, fragment, first make sure that the Ignore blank pages checkbox is selected, and then specify the necessary pages or page range to print based on the page numbering in the preview area.
Scale and page breaks
Scale	Actual size Fit to page: Place the entire selected fragment on one page. Fit to width: Fit all the columns of the selected fragment into one page. Fit to height: Fit all the rows of the selected fragment into one page.
Print with custom page breaks	This option is available if the sheet contains custom page breaks. When the option is selected, the sheet is divided into pages according to the inserted breaks. If there are no custom page breaks on the sheet, then this option is disabled.
Print titles
Rows to repeat / Columns to repeat	Select only entire rows or columns. For example, when you manually enter a range, you can't enter “ $A$1:$A$5 ”; you have to enter the address of the entire row “ $1:$1 ” or the range of rows “ $1:$5 ”. When using multiple columns or rows, only adjacent rows or columns can be selected. For example, when you enter a range manually, you cannot enter the ranges “ $1:$1 ” and “ $3:$3 ” without including the range “ $2:$2 ”. You also cannot specify a range as “ =$B:$C;$D:$E ”. You need to specify the range as a continuous one as “ =$B:$E ”. Select only rows or columns on the current document sheet and located in the sheet's workspace .
Margins
Top margin	The distance between the top edge of the page and the content of the document.
Bottom margin	The distance between the bottom edge of the page and the content of the document.
Left margin	The distance between the left edge of the page and the content of the document.
Right margin	The distance between the right edge of the page and the content of the document.

tip

Print settings that are not supported by the printer are not available in the Page setup and print window.

Click Print to print the document, or Cancel to close the window.

The page settings specified for the current sheet can be saved for subsequent printing sessions. To save the settings and close the window, click Save. To print the document and save the settings, click Print.

The page settings specified for printing the selection are applied only during the current session. Saving these settings is not available.