What is the easiest way to fit a table on one page in Excel?

On the Page Layout tab, set Width = 1 page and Height = Automatic (or 1 page), then set the print area. If the text is too small in Print Preview, narrow the margins or reduce the column and row sizes.

How do I repeat a header row on every page?

In Page Layout > Print Titles, specify the header row in Rows to repeat at top, such as $1:$1.

How do I fix gridlines not printing?

Select 'Print (Gridlines)' under Sheet Options on the Page Layout tab. Simply showing gridlines on screen does not print them.

Why does my PDF change to Letter even though I set it to A4?

The printer's default paper size may be Letter. Set the paper size to A4 in Page Setup, then save as a PDF.

The text is too small after fitting the sheet on one page. What should I do?

Set Height to 'Automatic' instead of 1 page, adjust the margins and column widths, or switch to Landscape orientation to reduce scaling.

CONTENTS

Print Excel on One Page: Page Setup, Margins, Repeating Headers, and PDF

To accurately print an Excel worksheet on one page, you need to adjust the print area, paper size, and scaling together. Follow the steps below to create a clean one-page PDF.

Quick Fix (3 Minutes)

Select the table → Page Layout > Print Area > Set Print Area
Switch the orientation to Landscape (for wide tables)
Use scaling to set Width = 1 page and Height = Automatic (or 1 page)
Check File > Print preview. If the text is too small, adjust the margins or column widths.
Set Rows to repeat at top in Page Layout > Print Titles

Key Concepts: Print Area, Page Size, and Scaling

Print area: The range of cells to print
Page size: A4/Letter and orientation
Scaling: Reducing or enlarging content to fit on a page

Three Ways to Fit Content on One Page

1) Scale to Fit

Set the width and height in Page Layout. If the content becomes too small, leave the height set to Automatic and adjust the margins and columns/rows.

2) Page Break Preview

Go to View > Page Break Preview and drag the blue lines to adjust page breaks manually.

3) Print Titles + Centering

Set repeating rows or columns in Print Titles, then select Horizontally and Vertically under Page Setup > Margins.

Repeating Headers, Gridlines, and Logos

Rows to repeat at top: $1:$1
Print gridlines: Sheet Options > Print (Gridlines)
Header/footer: Insert a logo and page numbers with &[Page]/&[Pages]

Page Breaks and Margins

Insert or remove breaks: Page Layout > Breaks
Fine-tune with Narrow or Custom Margins
AutoFit columns/rows: Windows KeyTips Alt, H, O, I / Alt, H, O, A

Save as PDF + A4/Letter

Select File > Export > PDF, or choose PDF as the print destination.
Set the paper size to A4 consistently for each document to prevent layout shifts.

Troubleshooting

Issue	Cause	Solution
Text is too small	Content is overly reduced because Height = 1 page	Set Height = Automatic, adjust margins/columns/rows, and use Landscape orientation
Headers disappear	Repeating rows were not specified	Set `$1:$1` in Print Titles
Gridlines do not print	Only display is enabled	Select Print (Gridlines) in Sheet Options
Blank last page	Empty space after the print area	Reset the print area and delete trailing rows/columns
PDF uses Letter size	The printer default is Letter	Set the paper size to A4 before saving

Checklist and Wrap-Up

Set the print area
Check width, height, and orientation
Confirm repeating headers, gridlines, and centering
Check the paper size (A4/Letter) and PDF save settings

CSV 파일이 엑셀에서 깨져 보일 때 대처법 — UTF-8/CP949, 구분기호, 자동변환, 대용량까지