Set Print Area and Page Break

Set Print area

  1. Click 'Page Break Preview' button from ribbon menu, and then screen setting is changed to page break preview.
../../../_images/img_01.en208.png
  1. Select cell range of printing in sheet, right-click and then select 'Set Print Area' menu.
../../../_images/img_02.en192.png

Tip

After setting print area, selected range is surrounded by blue frame.

../../../_images/img_03.en154.png
  1. Save sheet.

Insert Page Break

  1. In page break preview, select the cell under the location to break, right-click and then select 'Insert Page Break' menu.
../../../_images/img_04.en135.png

Tip

After inserting page break, added new break location is displayed with blue solid line.

../../../_images/img_05.en120.png
  1. Save sheet.

See also

See Print the sheet for more information on print settings.

Tip

When you export the CELF sheet to Excel , the set printing range, manually inserted page break position information and the set print settings will also be exported.

Attention

The page break position may differ depending on the display magnification rate set on the device. In that case, adjust the display magnification ratio to the value when page breaks are set.

Also, the following restrictions apply to the print settings exported to Excel.

  • If a manual page break is inserted, the scale value (scaling factor) calculated by CELF will be applied to the Excel sheet. This may cause the layout to be somewhat smaller in the exported Excel sheet.
  • The page break position may differ between CELF and Excel except for the page break position manually inserted.

Related keywords

form, report, printer, print