How to Print in Excel: Page Setup, Print Area and Titles

Last updated: November 2026 · Works in Excel for Microsoft 365, Excel 2021, Excel 2019 and Excel 2016

A spreadsheet that looks perfect on screen can print as twelve pages, with one stray column on each page and no headings after page one. Excel's page setup tools fix all of this, and a few minutes spent on them makes reports, invoices and price lists look professional on paper and in PDF. This guide covers the settings that make the biggest difference, in the order you would normally use them.

Always preview first

Press Ctrl + P to open the Print screen. The right side shows exactly how each page will look, and the arrows at the bottom move between pages. Check how many pages there are before you print anything. The settings on the left, such as orientation and scaling, can be changed here and the preview updates immediately. Most of the fixes below can be made from this screen or from the Page Layout tab.

Set the print area

By default Excel prints everything it thinks is used on the sheet, which can include notes, workings or a stray value far to the right. To print only part of the sheet, select the range you want and choose Page Layout > Print Area > Set Print Area. Excel remembers this with the workbook. To print a selection just once, select it, press Ctrl + P and change the first setting from Print Active Sheets to Print Selection.

If the print area includes a large empty region, press Ctrl + End to see where Excel thinks the sheet ends. Delete any unused rows and columns beyond your data and save the file to reset it.

Orientation and paper size

Wide tables with many columns usually fit better in Landscape; long lists suit Portrait. Change this under Page Layout > Orientation. In the UAE and most countries outside North America, check that Size is set to A4 rather than Letter. Files created on a computer with US settings default to Letter, which can push the last column or rows onto an extra page.

Fit to one page wide

The most useful scaling option is not "fit everything on one page", which can shrink a long list until it is unreadable. Instead, fit the width only. On the Page Layout tab, in the Scale to Fit group, set Width to 1 page and leave Height on Automatic. Every column now fits across the page, and Excel uses as many pages as needed going down. In the Print screen the same option is called Fit All Columns on One Page.

Keep an eye on the Scale percentage shown in the group. If it drops below about 60%, the text will be hard to read. Hide columns that are not needed for the printout, narrow wide columns, or switch to landscape instead.

Repeat header rows on every page

A long list is hard to follow when only page one shows the column headings. Go to Page Layout > Print Titles. In the Rows to repeat at top box, click and then select the header row on the sheet, for example row 1 (Excel writes $1:$1). Click OK. The headings now print at the top of every page. Use Columns to repeat at left in the same way for wide sheets where the first column holds names or codes.

This is different from Freeze Panes, which keeps headings visible on screen but has no effect on printing. See our worksheet guide for freezing panes.

Control page breaks with Page Break Preview

Choose View > Page Break Preview. The sheet shows each printed page with a large grey page number, and blue lines mark the breaks. Dashed lines are automatic breaks; solid lines are ones you have set. Drag a blue line to move a break, for example so a group of rows is not split across two pages. Dragging the outer blue border changes the print area. To insert a break manually, select the row below where the new page should start and choose Page Layout > Breaks > Insert Page Break. Return to normal with View > Normal.

Choose Insert > Header & Footer, or switch to View > Page Layout and click the header area. Each header and footer has left, centre and right sections. The Header & Footer tab offers ready-made elements:

A typical professional layout puts the report title in the centre header, the file name in the left footer and "Page 1 of 5" in the right footer.

Gridlines, margins and centring

Save as PDF

To email a report, choose File > Save As or File > Export and select PDF. The PDF uses all your page setup settings. Click Options to choose between the active sheet, the whole workbook or a selection. Sending a PDF instead of the workbook means the recipient sees exactly what you intended and cannot change the figures.

Printing several sheets at once

Hold Ctrl and click several sheet tabs to group them, then press Ctrl + P. Page setup changes made while sheets are grouped apply to all of them, which saves time with monthly sheets that share a layout. Right-click a tab and choose Ungroup Sheets afterwards, otherwise any typing will also go into every grouped sheet.

Summary

Back to: all Excel tutorials.