Excel Print Settings Explained: Print Area, Scaling and Page Breaks

An Excel workbook is laid out for a screen with no edge. A printed page has an edge, and the settings that decide what lands on which page are stored in the workbook, sheet by sheet. When a printout goes wrong, the cause is almost always one of the settings below.

The print area

If no print area is set, Excel prints the used range of the sheet, everything from A1 to the last cell with content or formatting. Stray formatting far to the right or down is the usual reason a short table prints on many pages. A print area (a defined name, _xlnm.Print_Area) limits printing to the cells you choose, and a sheet can have several areas, each of which starts on its own page. If rows are deleted that the print area referred to, the stored reference can break (#REF!), and Excel then prints as if there were none.

Paper, orientation and margins

The page setup stores a paper size code, an orientation and margins. If no paper size is stored, the printer's default is used: Letter on many US printers, A4 elsewhere, so page breaks fall in different places on different computers. A wide table usually needs landscape. Margins below about a quarter inch can fall outside what a printer can reach, and very wide margins waste the page.

Scale and Fit To

Excel can print at a fixed percentage (Adjust to), or shrink the content to fit a number of pages wide and tall (Fit To). Fit to 1 page wide by 1 tall on a sheet with 900 rows produces text so small it is unreadable; the usual fix is to fit 1 page wide and leave the height empty so the sheet runs over as many pages as it needs. A related trap: Excel ignores manual page breaks when Fit To is on.

Page breaks and repeated headers

Automatic page breaks fall where the page fills up. Manual breaks (a row or column break) override them, but only outside Fit To. When a table spans several pages, Print Titles (_xlnm.Print_Titles) repeat chosen rows, usually the header row, at the top of each page, and columns at the left. Without them, page two onward is a block of numbers with no labels. Page numbers in the header or footer keep a stack of pages in order.

Hidden rows, columns and sheets

Hidden rows and columns do not print. A hidden sheet, or a very hidden one, is skipped when you print the whole workbook, so it adds no pages. Charts and pictures placed outside the print area are not printed either.

Checking before you print

Print preview shows one sheet at a time. The Excel Print Layout Preflight Checker reads the stored settings of every sheet in a workbook at once and gives PASS, WARNING or FAIL for each check with the Excel setting to change. Its page counts are estimates from the stored widths, heights, scale and paper size: Excel's real pagination also depends on the printer driver, fonts and automatic row height for wrapped text.

If the end goal is a PDF, check the exported file afterwards with the PDF Page Size Analyzer. If you share the workbook, check what else is in it with the Send-Safe Document Checker, since hidden sheets that do not print are still in the file. For spreadsheets that receive CSV data, see CSV injection explained.