Professional Excel output requires mastering print setup and page layout. This comprehensive guide covers everything from basic print settings to advanced techniques for creating polished reports, presentations, and PDF documents.
Understanding Page Layout
Excel's Page Layout view shows how your spreadsheet will appear when printed, including margins, headers, footers, and page breaks.
Accessing Page Layout View
View tab → Page Layout
Status bar → Page Layout button
Keyboard: Alt + W, P
Page Layout vs Normal View
Normal View: Best for editing, no page boundaries shown
Page Layout View: Shows print preview with headers/footers
Page Break Preview: Shows and allows editing of page breaks
Essential Print Settings
Page Setup Dialog
Access: Page Layout → Page Setup dialog launcher (small arrow)
Page Tab:
Orientation: Portrait or Landscape
Scaling: Adjust to fit paper
Paper size: Letter, Legal, A4, etc.
Print quality: Draft or high quality
First page number: Custom starting number
Margins Tab:
Top, Bottom, Left, Right margins
Header and Footer spacing
Center on page: Horizontally and/or Vertically
Header/Footer Tab:
Custom headers and footers
Different first page
Different odd/even pages
Scale with document
Sheet Tab:
Print area definition
Print titles (rows/columns to repeat)
Gridlines and headings
Page order
Setting Print Areas
Define Print Area
1. Select the range to print
2. Page Layout → Print Area → Set Print Area
Clear Print Area
Page Layout → Print Area → Clear Print Area
Mu