To set up print options, use the Print group of parameters on the parameters panel:

To open the group of parameters
Execute one of the operations:
Select the Page Settings item in the Page Layout group in the main menu.
Open the data entry form for preview:
Select the File > Print > Preview item in the main menu.
Click the
Print button on the Home toolbar tab.
Press CTRL+P.
Click the
Page Settings button at the top right corner.
Go to the Print group of parameters.

Set the parameters:
In the Print Area box set the cell range to be printed.

Pass-through rows and pass-through columns
Set row and/or column ranges, which are required to print on every page in the Pass-Through Rows and Pass-Through Columns boxes.
When setting row and column ranges consider the following:
Ranges for pass-through rows and columns must include whole rows or columns.
On entering a composite range, ranges are separated with ";".
If the cell range entered using the keyboard does not contain full rows/columns, it will be replaced with full row/column ranges containing the selected cells. For example, if the pass-through rows were entered: A1:F1; A10:A12, they will be replaced with 1:1; 10:12.
If intersecting or adjacent ranges are set (for example, 0:0 and 1:1), they are merged into one range.
If several ranges are set, they will be ordered in the Pass-Through Rows and Pass-Through Columns boxes from top to bottom for rows and from left to right for columns.
NOTE. Using a Fore macro, using the TitleRowsScope/TitleColumnsScope properties, one can limit the scope of pass-through rows and columns.
To set up page order during printing, select the option in the drop-down list:
Left, then Right. Data entry form pages are printed first to the left, then to the right.
Up, then Down. Data entry form pages are printed first up, then down.
When a composite range of pass-through rows/columns is set, take into account the following output order features:
If two or more ranges of pass-through rows were set, the data located between the first and the second range of pass-through rows are output first, then those between the second and the third range, and so on. If in this case the range of pass-through columns was set, it is interrupted with the ranges of pass-through rows.
If a data entry form contains several tables that fit to width of one sheet, pass-through rows are set for the table, and there is still free space after the table is output to the page, the next table will be output to the same page considering the pass-through rows specified for this table and at least one data row.
When a pass-through row is set for several tables located one after another, consider that the range of pass-through rows is set for a whole row and not for a cell range.
If two or more ranges of pass-through columns were set, the data located between the first and the second range of pass-through columns is output first, then those between the second and the third range, and so on. If in this case the range of pass-through rows was set, it is interrupted with the ranges of pass-through columns.
If a data entry form contains several tables that fit to height of one sheet, pass-through columns are set for the table, and there is still free space after the table is output to the page, the next table will be output to the same page considering the pass-through columns specified for this table and at least one data column.
On setting a pass-through column for several tables located one after another, consider that the range of pass-through columns is set for a whole column and not for a cell range.
To print data entry form t title, select the Print Title checkbox.
NOTE. The title is displayed only on the first page of each data entry form sheet.
The data entry form title can be set up on the Title tab.
To print the current data entry form sheet, select the Print Sheet with Report checkbox. The checkbox is selected by default.
When the checkbox is deselected, the data entry form sheet is not printed. Consider that:
When the entire data entry form is printed, this sheet is not printed.
When exporting data entry form to PDF and RTF this sheet is unavailable for export.
When the Print Header or Print Footer checkbox is deselected, header or footer is hidden.
If the Black-and-White Printing checkbox is selected, all color formatting is reset on preview and print: the whole text, headers and footers are printed in gray shades regardless of the specified colors, the background is white. The checkbox is deselected by default.
NOTE. If black-and-white printing is used, image quality can be worse on preview. This does not affect the printing quality.
After executing the operations the print options are set.
See also:
Setting Up Data Entry Form for Printing