Module 03 · Lesson 09
Print setup, step by step
Eight settings, in this order, every time.
- 1
Page Break Preview. View › Page Break Preview. Blue lines show where each page ends; drag them.
- 2
Set Print Area. Select A1:E220 › Page Layout › Print Area › Set Print Area.
- 3
Paper & orientation. Page Layout › Size: A4 · Orientation: Portrait for lists, Landscape for wide tables.
- 4
Margins. Narrow, and in Custom Margins tick Center on page: Horizontally.
- 5
Scaling. Ctrl+P › No Scaling › Fit All Columns on One Page.
- 6
Print Titles. Page Layout › Print Titles › Rows to repeat at top › click row 4 ($4:$4).
- 7
Header & footer. Page Setup › Header/Footer › Footer: Page 1 of ? · Header: title or date.
- 8
Preview & save PDF. Ctrl+P › check every page › Printer: Microsoft Print to PDF, or File › Export › PDF.