Skip to content

Module 03 · Lesson 09

Print setup, step by step

Eight settings, in this order, every time.

Printing Excel6 min
  1. 1

    Page Break Preview. View › Page Break Preview. Blue lines show where each page ends; drag them.

  2. 2

    Set Print Area. Select A1:E220 › Page Layout › Print Area › Set Print Area.

  3. 3

    Paper & orientation. Page Layout › Size: A4 · Orientation: Portrait for lists, Landscape for wide tables.

  4. 4

    Margins. Narrow, and in Custom Margins tick Center on page: Horizontally.

  5. 5

    Scaling. Ctrl+P › No Scaling › Fit All Columns on One Page.

  6. 6

    Print Titles. Page Layout › Print Titles › Rows to repeat at top › click row 4 ($4:$4).

  7. 7

    Header & footer. Page Setup › Header/Footer › Footer: Page 1 of ? · Header: title or date.

  8. 8

    Preview & save PDF. Ctrl+P › check every page › Printer: Microsoft Print to PDF, or File › Export › PDF.