Free PDF checklist
Get the Printing Checklist
A one-page checklist for cleaner Excel printouts.
Enter your email for instant access.
Free. Instant access. One-page PDF.
How Do You Stop Excel From Cutting Off Columns When Printing?
If you just need to fix cut-off columns right now, here’s the fastest solution:
- Press Ctrl+P (or File → Print)
- Under Scaling, choose Fit All Columns on One Page
- Check the preview – if it’s readable, you’re done
- If your table is wide, switch Orientation to Landscape
How to Open and Read Excel Print Preview
Before you print anything, open Print Preview. This single step prevents 90% of Excel printing problems.
- Go to File → Print (or press Ctrl+P).
In Print Preview, check three things immediately:
- Page count: How many pages will this actually print?
- Layout: Does your data fit the way you expect?
- Cut-off content: Are columns or rows disappearing off the edge?
💡 Pro tip: Add “Print Preview and Print” to your Quick Access Toolbar so you can open it in one click every time.
Excel Print Settings: What to Print, Orientation, Margins, and Scaling
Excel gives you several critical print settings. Understanding what each one does will save you hours of frustration.
Choose What to Print: Active Sheets vs. Entire Workbook
Control exactly which parts of your workbook print:
- Print Active Sheets: Only the sheet tab(s) you’ve selected
- Print Entire Workbook: Every sheet in the file (use sparingly)
- Print Selection: Only cells you highlighted before opening Print Preview
💡 Pro tip: To print multiple specific sheets (but not the whole workbook), hold Ctrl and click each sheet tab, then choose Print Active Sheets
Portrait vs. Landscape Orientation in Excel
- Portrait (tall): Best for narrow tables with few columns
- Landscape (wide): Best for wide tables with many columns
If your data has more than 5-6 columns, try Landscape first.
Adjust Margins to Fit More Content
Normal margins work fine most of the time. But if you’re close to fitting everything on one page, switch to Narrow margins.
Advanced option: To center your printout on the page, choose Custom Margins, then check Horizontally and Vertically under “Center on page.”
Use Scaling to Fit Your Spreadsheet on One Page
Scaling shrinks your printout to fit more content on fewer pages. This is the setting most people need when Excel cuts off columns.
Your scaling options:
- No Scaling: Print at actual size (often too big)
- Fit Sheet on One Page: Shrink everything to one page (can get tiny)
- Fit All Columns on One Page: Best for wide tables—keeps columns together
- Fit All Rows on One Page: Best for tall tables
Warning: Always check readability after scaling. If someone needs a magnifying glass to read your printout, it defeats the purpose.
Featured Course
Excel Essentials for the Real World
How to Repeat Headers on Every Printed Page in Excel
If your spreadsheet prints on multiple pages, repeating headers is non-negotiable. Without it, page 2 becomes unreadable—your readers won’t know what each column represents.
How to set Print Titles:
- Go to Page Layout → Print Titles
- This opens the Page Setup dialog on the Sheet tab
Under Print titles, you’ll see two fields:
- Rows to repeat at top: Your column headers
- Columns to repeat at left: Your row labels
Examples:
- $1:$1 = repeat only row 1
- $1:$3 = repeat rows 1 through 3
- $A:$A = repeat only column A
- $A:$C = repeat columns A through C
For a detailed guide with a video tutorial check out this blog post.
How Do You Fix Page Breaks in Excel?
Excel inserts page breaks automatically based on paper size and scaling, but they often land in awkward spots like splitting a category across two pages.
You can override them with manual breaks or by dragging breaks visually in Page Break Preview mode.
Insert a Manual Page Break
- Click the cell where you want the new page to start
- Go to Page Layout → Breaks → Insert Page Break
💡 Pro tip: After you open Print Preview once, Excel shows page breaks as light dotted lines directly on your sheet.
Use Page Break Preview Mode
For the most intuitive control over page breaks, switch to Page Break Preview mode:
- Go to View → Page Break Preview
In this view:
- Solid blue lines = manual breaks you created
- Dashed blue lines = automatic breaks from Excel
- Drag any line to reposition page breaks
How to Add Page Numbers and Headers in Excel
For multi-page printouts, page numbers aren’t optional—they’re essential. Headers and footers also let you add dates, file names, or company logos.
How to add headers and footers:
- Go to View → Page Layout
- Click “Add header” or “Add footer”
- This opens the Header & Footer ribbon
From the Header & Footer ribbon, you can insert:
- Page numbers (e.g., “Page 1 of 5”)
- Current date or time
- File name or sheet name
- Pictures or company logos
💡 Pro tip: Headers and footers each have three sections (left, center, right). You can type custom text in any section alongside the dynamic elements.
How to Set a Print Area in Excel
If you only want to print a specific section of your sheet every time, set a Print Area. This saves you from selecting the range manually each time you print.
How to set a Print Area:
- Select the cells you want to print
- Go to Page Layout → Print Area → Set Print Area
Now only that area will print, even when you choose “Print Active Sheets.” You don’t have to remember to select it each time.
To remove it later: Page Layout → Print Area → Clear Print Area
If your sheet has data scattered across non-contiguous ranges, hide the rows and columns you don’t want to print instead of setting a print area. Hidden rows and columns don’t print
How to Save Excel as PDF (3 Methods)
Most people save Excel files as PDFs more than they print on paper. Here are three methods that all work reliably.
Method 1: Export to PDF
- Select the sheets you want to export
- Go to File → Export → Create PDF/XPS
- Click “Create PDF/XPS”
Choose your quality:
- Standard: Better quality for printing
- Minimum size: Smaller file for emailing
Method 2: Print to PDF
This method is often the best because you see the exact preview before saving.
- In File → Print, select Microsoft Print to PDF as your printer
- Adjust all your settings in Print Preview
- Click Print and choose where to save the PDF
Method 3: Save As PDF
- Go to File → Save a Copy (or Save As)
- Change the file type dropdown from xlsx to PDF
- Click Save
Why Is My Excel Not Printing Correctly? (Common Problems Fixed)
Most Excel printing problems come from five specific issues. Here’s how to fix each one in under a minute.
Excel Is Printing Blank Pages
Blank pages usually mean Excel detected stray content far below your data, often from a stray space or formatting in an empty cell. Fix it by setting a Print Area: select your actual data, then go to Page Layout → Print Area → Set Print Area. If that doesn’t work, press Ctrl+End to find Excel’s last used cell. If it lands far below your data, delete the empty rows and columns between, save the file, and try again.
If Ctrl+End lands far below your data, you likely have invisible empty rows. Use this guide to remove blank rows in Excel before resetting your print area.
Gridlines Aren’t Printing
Gridlines are off by default when printing. Turn them on under Page Layout → Sheet Options → Gridlines → Print. The same panel has a Print checkbox for row and column headings (A, B, C and 1, 2, 3) if you need those visible too.
Excel Prints Too Small to Read
This happens when “Fit Sheet on One Page” shrinks a wide table down to 30% scaling. Switch to Fit All Columns on One Page instead, which keeps rows at readable size and lets the printout flow across multiple pages. If it’s still tight, switch to Landscape orientation and Narrow margins before reducing scale further.
Print Preview Looks Different From the Actual Printout
Excel renders Print Preview using the selected printer’s driver. If you switch printers, the preview redraws with that printer’s margins and page size. Always select the correct printer first under File → Print → Printer dropdown, then check the preview.
One Column Spills Onto a Second Page
Use Page Break Preview (View → Page Break Preview) and drag the dashed blue line to the right edge of your last column. This forces Excel to fit everything within one page width. Combine with Landscape orientation if needed.
Final Excel Printing Checklist
Before you print or save to PDF, check these five things in Print Preview:
- Does it look right? Check for cut-off content
- Is orientation correct? (Portrait for narrow, Landscape for wide)
- Does it fit on the pages you want? Use scaling if needed
- Are headers/footers set? Page numbers for multi-page docs
- Are Print Titles set? Headers must repeat on every page
Download our free one-page Excel Printing Checklist and keep it at your desk for reference.
Common Excel Printing Questions
How do I print in Excel without cutting off columns?
Go to File → Print, then under Scaling choose Fit All Columns on One Page. If your table is wide, also switch Orientation to Landscape.
How do I repeat headers on every page when printing Excel?
Go to Page Layout → Print Titles, then set Rows to repeat at top (example: $1:$1 to repeat row 1).
How do I adjust page breaks in Excel?
Use View → Page Break Preview. Dashed blue lines are automatic breaks you can drag. Solid blue lines are manual breaks.
To insert a manual break, click where you want the page to start and go to Page Layout → Breaks → Insert Page Break.
What’s the best way to convert Excel to PDF?
Use File → Print, select Microsoft Print to PDF as your printer, adjust all your settings in Print Preview, then click Print.
This lets you see exactly what you’re saving.
Keep this guide bookmarked and run through the checklist before every print job. Five seconds in Print Preview saves five minutes at the printer.
Ready to print like a pro?
Get the one-page Excel Printing Checklist (PDF). Print it once, keep it at your desk for every print job.
Download Checklist →Featured Bundle
Black Belt Excel Bundle
Leila Gharani
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
