Page layout, print and PDF

Page setup

The Page Layout tab sets margins, orientation, paper size, print area, print titles, scaling (including fit to a number of pages) and whether gridlines and headings print. Settings are stored in the workbook in Excel's format, so a file prints the same way in both apps.

Headers and footers support Excel's codes for page numbers, dates, the file and sheet name, and a picture, with different first and odd and even pages.

Views

  • Page Layout view shows the sheet as pages with their margins, headers and footers.
  • Page Break Preview shows where pages break; drag a break to move it.
  • Normal view goes back to the grid.

File > Print (Cmd+P) opens a preview of the actual pages. From there you can print through your browser or choose Save as PDF.

The PDF is written by 8sheets itself, page by page, so large workbooks don't need to fit in memory at once. Charts, shapes, pictures, sparklines, conditional formatting and slicers appear in print as they do on screen.