PrintCtrl+PPDF Output

Open Print Preview Instantly with Ctrl+P —
5 Things to Check Before Printing

Realizing 'the columns overflowed to another page' or 'a blank page got added' only after pressing print is a classic waste of time and paper. Build the habit of checking the preview with Ctrl+P first.

Shortcuts you will master in this article

Ctrl + P

Problems caught after printing can be prevented with a preview check

The most common Excel print issues are: columns spilling to a second page, blank pages being added at the bottom, and headers appearing only on the first page. All of these can be caught and corrected in the print preview before printing.

Pressing Ctrl+P opens both the print settings panel and the preview simultaneously. Adjust 'Fit to page' and 'Page Setup' here before printing.

5 Things to Check Before Printing

A step-by-step process from opening Ctrl+P to sending to print.

Ctrl + P

Open print preview

The print dialog and a preview open together. Check the overall layout here.

Tip: Press Esc to cancel without printing. You can review the preview without actually printing.

Check the page count

Make sure no unintended pages have been added

The page count is shown at the bottom of the preview (e.g., '1 / 3'). Check for blank pages.

Tip: Extra pages are often caused by stray spaces or borders outside the main table area.

Use 'Fit All Columns on One Page'

Fix columns spilling to the right

Change the scaling option from 'No Scaling' to 'Fit All Columns on One Page' to compress everything to a single width.

Tip: If there are many rows, using 'Fit All Columns on One Page' while keeping rows as-is produces more readable output.

Verify the header repeat setting

Apply headers to every page in multi-page tables

In Page Setup under the 'Sheet' tab, specifying a 'Rows to repeat at top' ensures headers appear on every page when printed.

Tip: Always set this for long lists that span multiple pages.

Saving as PDF instead

Select PDF from F12

Instead of Ctrl+P, using F12 and selecting 'PDF' saves the output as a file.

Tip: If the goal is digital sharing rather than physical printing, PDF output prevents layout inconsistencies.

Excel Shortcut Practice

Master Excel shortcuts and
gain real productivity skills

Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.

Start shortcut practice →View all shortcuts

Building a Pre-Print Review Habit

Open Ctrl+P preview and always check page count and column overflow.

For multi-page lists, set 'Rows to repeat at top' in Page Setup.

For digital sharing, PDF output is safer than printing.

Related Shortcuts

Visit each shortcut detail page to see key positions and usage tips.

Key	Action
`Ctrl + P`	Print
`F12`	Save As

Frequently Asked Questions

Q. How do I limit what gets printed to a specific cell range?

A. Select the range, then go to Page Layout → Set Print Area. When you open Ctrl+P, only that range will appear in the preview.

Q. How do I fix columns overflowing to the right when printing?

A. In the Ctrl+P preview, change the scaling option to 'Fit All Columns on One Page'.

Q. Does Ctrl+P work in Mac Excel?

A. Cmd+P is the print command on Mac. It works the same way as Ctrl+P on Windows.

Q. How do I memorize Excel shortcuts faster?

A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.

Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説

解説記事を読む →