CONTENTS

Complete Guide to Excel Print Settings: From Fitting to One Page to PDF

Excel print settings can be frustrating when a table that looks fine on screen gets cut off or has misaligned margins when printed. This guide covers everything about Excel print settings, from the basics to fitting to one page, margins, headers and footers, repeating rows and columns, saving as PDF, watermarks, and print quality. Follow along to create a clean printout in one go.

Quick Fix (3 Steps for a Clean Printout)

Press Ctrl + P → check the Print Preview first
Go to [Page Layout] → Scale to Fit and set Width = 1 page, Height = Automatic (or 1 page)
To print only a specific area: select the range → [Page Layout] → Print Area → Set Print Area → print

1) Why Excel Printing Is Difficult (Concepts and Basics)

Different standards for monitors vs. printers: pixels versus points/millimeters
Page breaks: determined by table size, margins, scaling, paper size, and orientation
Three key elements: paper, margins, and scaling
Keyboard shortcuts: Ctrl+P, Ctrl+F2, Alt+P…

2) Set a Print Area: Print Only What You Need

Select the range → [Page Layout] → Print Area → Set Print Area (to clear it, select Clear Print Area). You can select additional areas by holding Ctrl.

3) Paper, Orientation, and Margins: The Basics to Prevent Cutoffs

Paper size: Match the document standard, such as A4 or Letter
Orientation: Switching to Landscape significantly reduces cutoffs
Margins: Use Narrow or Custom Margins, and select Center on page (Horizontally/Vertically)

4) Fit to One Page

Under [Page Layout] → Scale to Fit, set Width = 1 and Height = Automatic or 1. If the text is too small, set Height to 2.

5) Headers and Footers

Page numbers: &[Page] / &[Pages]
Date/time: &[Date], &[Time]
File path/name: &[Path]&[File]

6) Repeat Rows and Columns (Print Titles)

Go to [Page Layout] → Print Titles → enter $1:$1 in Rows to repeat at top and $A:$A in Columns to repeat at left.

7) Save as PDF

Select File → Print → Printer = PDF or Save As → PDF. Choose the Standard or Minimum Size option.

8) Print Quality & Watermarks

Save costs with black-and-white or grayscale printing
Printer quality mode: draft versus high quality
Watermarks: insert a picture in the header or use light WordArt text

9) Page Break Preview

Go to [View] → Page Break Preview and drag the boundaries to adjust them.

10) Sample Data

No.	Department	Item	Quantity	Unit Price	Amount
1	Sales	Item A	12	8,000	96,000
2	Sales	Item B	5	15,000	75,000
3	Manufacturing	Item C	48	2,900	139,200
4	Human Resources	Item D	7	11,000	77,000
5	Finance	Item E	33	4,200	138,600
6	Sales	Item F	21	6,800	142,800
7	Manufacturing	Item G	16	5,500	88,000
8	Human Resources	Item H	24	3,700	88,800
9	Finance	Item I	9	19,000	171,000
10	Sales	Item J	61	1,800	109,800

Set Width = 1 and Height = Automatic → check the preview
Set the repeating row to $1:$1
Add &[Page]/&[Pages] to the header
Set margins to Narrow + center on page
Save the PDF at Standard quality

11) Alternative Methods and Automation Tips

Use Custom Views to save print setting scenarios
Use a defined name for a dynamic print area that expands automatically
Standardize for your team with templates (xltx)
Use macros to apply print settings in bulk

12) Troubleshooting Common Problems

Issue	Cause	Solution
Table is cut off horizontally	Paper, orientation, or scaling mismatch	Set Orientation = Landscape, Width = 1 page, Margins = Narrow
Blank pages print	Hidden rows/columns or header picture size	Reset the print area and reduce the header picture size
Uneven margins	Printer default margins or driver	Use Custom Margins and check printer properties
Page numbers are incorrect	Duplicate headers/footers	Add page numbers in only one location
PDF is distorted	Scaling or font embedding issue	Recheck Fit to One Page and embed fonts
Header disappears	Repeat rows/columns not set	Set `$1:$1` in Print Titles

13) Checklist

Check paper, orientation, margins, and scaling
Repeat header rows on every page
Add page numbers and the file path to the header/footer
Center on page
PDF preview = final copy

{ “@context”: “https://schema.org”, “@type”: “FAQPage”, “mainEntity”: [ { “@type”: “Question”, “name”: “How do I print in Excel to fit on one page?”, “acceptedAnswer”: { “@type”: “Answer”, “text”: “Under [Page Layout] → Scale to Fit, set Width = 1 and Height = Automatic (or 1). Narrow margins and centering on the page are recommended. Check the text size in Print Preview with Ctrl+P.” } }, { “@type”: “Question”, “name”: “Can I print only a selected area?”, “acceptedAnswer”: { “@type”: “Answer”, “text”: “Select the desired range, then go to [Page Layout] → Print Area → Set Print Area before printing. To remove it, select Clear Print Area.” } }, { “@type”: “Question”, “name”: “How do I repeat a header row on every page?”, “acceptedAnswer”: { “@type”: “Answer”, “text”: “Go to [Page Layout] → Print Titles and specify the row containing the header in Rows to repeat at top, such as $1:$1. If needed, enter $A:$A in Columns to repeat at left.” } }, { “@type”: “Question”, “name”: “How can I reduce distortion when saving as a PDF?”, “acceptedAnswer”: { “@type”: “Answer”, “text”: “First set Fit to One Page, margins, and repeating rows. Then select a PDF printer under File → Print and save at Standard quality. Using a font embedding option can also help.” } }, { “@type”: “Question”, “name”: “How do I add page numbers and the file path?”, “acceptedAnswer”: { “@type”: “Answer”, “text”: “Add the &[Page]/&[Pages] and &[Path]&[File] codes to the header or footer to automatically display page numbers and the file path and name.” } } ] }

엑셀 앞자리 0 사라짐: 전화번호·우편번호 완벽 해결

Excel Print Settings Guide: Fit to One Page, Margins, and PDF