Excel Printing Basics: Check the "Horizontally" Box in "Page Margins"!
Summary
Excel printing is determined by "settings," not "tricks."
This article summarizes the basic steps for printing clearly and neatly on A4 paper without layout issues.
Are you having these problems?
A single column spills over onto the next page when printing
The margins are off for some reason, making it look bad
I don't know where the second page continues from
All of these can be solved with "settings."
What you can do with this article
Print with a neat layout on A4
Make multiple pages easier to read
Print with consistent quality every time
1. Basic Settings
First, let's set the foundation for printing.
1.1. Steps
(1) Click the "Page Layout" tab
(2) Click the small arrow in the bottom right (Page Setup)
1.2. Settings
(1) Paper size: A4
•(1) Orientation: Portrait
1.3. Key Point
Standardizing to A4 portrait makes documents stable.
2. Margin Settings (Adjusting the Appearance)
This is a crucial point that greatly affects the appearance of your printout.
2.1. Setting Values
• Top: 1.5cm
• Bottom: 1.5cm
• Left: 2.5cm
• Right: 1.5cm
2.2. Important Setting
• "Center on page" -> Check "Horizontally"
2.3. Terminology: Center on page (Horizontally)
This feature centers the print content horizontally.
Just by setting this, the appearance will be neat.
3. Displaying Title Rows at the Top of Every Page
If a table spans two or more pages, title rows are essential for the second page onwards.
3.1. Steps
(1) "Page Layout" tab
(2) Click "Print Titles"
(3) Select "Rows to repeat at top"
3.2. Setting Example
(4) Specify the second row -> "$2:$2"
3.3. Effect
Headings (item names) will be displayed on every page.
3.4. Click on the second row
3.5. "$2:$2" will be displayed in the title row.
4. Print Preview
Always check after configuring settings.
4.1. Steps
(1) "File" -> "Print" -> Preview display
4.2. Checkpoints
(1) Is the page cut off?
(2) Is the title displayed?
(3) If there are many pages, click the page number at the bottom center to check
5. Checking Page Breaks
You can check where the pages are divided.
5.1. Steps
(1) Click "Page Break Preview" at the bottom right of the screen
5.2. How to read
(1) Solid blue line: Print area
(2) Dotted blue line: Page break
5.3. Terminology: Page Break Preview
A screen where you can visually check the print area and page breaks.
6. How to fit printing onto one sheet
Use this when you want to fit a table onto one page.
6.1. Steps
(1) "Page Layout" tab
(2) Configure "Scale to Fit"
6.2. Settings
(1) Width: 1 page
(2) Height: 1 page
6.3. Terminology: Scale to Fit
A feature that shrinks the entire table to fit the specified number of pages.
6.4. Points to note
(1) Check if the text becomes too small
(2) Margins can remain as standard
(3) Keep "Center on page (Horizontally)" checked
(4) Confirm that the table is centered on one page in the page layout
7. Summary
Excel printing is not about "getting used to it" but about "settings".
Key points this time:
• Standardize to A4 portrait
• Improve appearance with margins + center alignment
• Make it easier to read with title rows
• Always check with preview
By learning these settings, you will almost never have printing failures.
8. Afterword
Printing in Excel can feel more difficult than in Word, but once you learn the settings, you can print with the same quality every time.
Please make use of this in your daily work and document creation.