You click Print and Excel spreads your table across five pages, with one lonely column on page 3. Sound familiar? Here’s how to make Excel print neatly on one page (or one page wide), every time.
Quick answer
- Press Ctrl + P.
- Under Settings, change No Scaling to Fit Sheet on One Page.
- Check the preview and click Print.
If the text becomes too small, use Fit All Columns on One Page instead (Way 2).
Way 1: Fit Sheet on One Page
File → Print (Ctrl + P) → Settings → Fit Sheet on One Page. Excel shrinks everything to fit one sheet of paper. It’s best for small and medium tables.
Way 2: Fit all columns on one page (best for long lists)
For long lists, the best option is usually one page wide, as many pages tall as needed:
- Ctrl + P → Settings → Fit All Columns on One Page, or
- Page Layout → Scale to Fit: Width = 1 page, Height = Automatic.
The text stays readable, and no columns get cut off.
Way 3: Set a print area
Only want to print part of the sheet?
- Select the range to print.
- Go to Page Layout → Print Area → Set Print Area.
To undo it: Page Layout → Print Area → Clear Print Area. Or for a one-off: select the cells, then Ctrl + P → Print Selection.
Way 4: Landscape and narrow margins
- Page Layout → Orientation → Landscape: wide tables fit much better.
- Page Layout → Margins → Narrow: gives you more space.
- Hide columns you don’t need to print (right-click the column → Hide).
- Reduce very wide columns, or turn on Wrap Text for long text.
Way 5: Adjust page breaks
- Go to View → Page Break Preview.
- Drag the blue dashed lines to where you want pages to break.
- Drag the solid blue border to include or exclude rows and columns.
- Go back with View → Normal.
Make multi-page printouts readable
Repeat the header row on every page
- Page Layout → Print Titles.
- In Rows to repeat at top, click the header row (e.g.
$1:$1). - Click OK.
This is the printing version of freeze panes.
Add page numbers and a title
Insert → Header & Footer → add Page Number and Number of Pages (“Page 1 of 3”), plus the file name or date.
Print gridlines (optional)
Page Layout → Sheet Options → Gridlines → Print. Or add proper borders, which look better.
Save as PDF instead
Ctrl + P → Printer → Microsoft Print to PDF (Windows), or File → Save As → PDF. Use the same scaling settings first. It’s great for sending schedules and reports by email or WhatsApp.
Google Sheets
File → Print (Ctrl + P) → Scale → Fit to page or Fit to width. Set orientation and margins on the same screen, then click Next.
Common problems
- A blank page prints at the end: there’s formatting or a stray value far below your data. Set a print area or clear those cells.
- Text is tiny: you’ve fitted too much on one page. Switch to landscape and fit columns only.
- Charts are cut off: check Page Break Preview and move the chart inside the print area. See how to make a good-looking chart.
Quick summary
- Ctrl + P → Fit Sheet on One Page for small tables.
- Fit All Columns on One Page + landscape for long lists.
- Set a print area, repeat header rows, and check Page Break Preview.