Spreadsheets are built for the screen, so the first printout often goes wrong: the last column lands alone on an extra page, the text is shrunk until it is unreadable, a hundred pages come out instead of three, or the header row is missing from page two. All of it is decided by a handful of print settings stored in the workbook. This tool reads them and tells you, sheet by sheet, what will happen.
It is a preflight, not an editor: nothing in the workbook is changed or calculated. The file is read in your browser and is not uploaded. Page counts are estimates and are labelled as such.
Loading the tool…
Overview
About Excel Print Layout Preflight Checker
What is read. From the .xlsx package (ECMA-376, SpreadsheetML): which sheets are visible, hidden or very hidden; the defined names _xlnm.Print_Area and _xlnm.Print_Titles; for each worksheet the page setup (paper size, orientation, scale, "fit to" width and height), margins, print options, manual row and column breaks, header and footer, column widths, row heights, hidden rows and columns, and where charts and pictures are anchored.
What is checked and explained.
- Print area: none set on a sheet that spans several pages, or a stored area that points to a deleted range.
- Paper size and orientation: no paper size stored (so the printer default decides), mixed paper sizes between sheets, wide content on a portrait page.
- Scaling: the effective size after "Fit to", with a warning below 70% and a failure below 50% so the printout does not turn into fine print; manual page breaks that Excel ignores when Fit To is on.
- Spill: columns that continue on extra pages to the right, including a narrow strip alone on the last page.
- Repeated header rows on multi-page sheets, and page numbers in the header or footer.
- Hidden content: hidden rows and columns inside the print range, a print range that is entirely hidden, hidden and very hidden sheets (which are not printed).
- Margins small enough to be clipped by a printer or so large that they waste the page; charts and pictures that start outside the print area.
- Page count: an estimate per sheet and for the whole workbook, with a warning above 30 pages per sheet and a failure above 100 (above 100 and 300 for the workbook).
How the page estimate works. The sheet is paginated on paper of the stored size using the stored column widths and row heights at the effective scale, honouring manual breaks. Excel's own pagination also depends on the printer driver, font metrics and automatic row height for wrapped text, none of which are in the file, so the number can differ from Excel's.
Read more. The guide Excel print settings explained covers print area, scaling, page breaks and repeated headers.
Compatibility
Supported Formats
.xlsx and .xlsm workbooks up to 100 MB. Chart sheets and special sheets are listed and not checked cell by cell. Not supported: .xls (old binary), password-protected workbooks and OpenDocument spreadsheets.
Guide
How to Use Excel Print Layout Preflight Checker
- Drop an .xlsx or .xlsm workbook onto the box. It is read in your browser.
- Read the overall result (PASS, WARNING or FAIL) and the workbook-level notes such as hidden sheets and total page count.
- Open each sheet. Every item says what it found, why it matters and the Excel setting to change.
- Fix the settings in Excel, then check the saved workbook again.
Highlights
Features
- PASS, WARNING, FAIL An overall verdict and one for every sheet, each finding with a plain explanation.
- Print area and titles Finds missing or broken print areas and header rows that do not repeat.
- Scaling and page breaks Effective scale after Fit To, spill to extra pages and manual breaks that are ignored.
- Hidden content Hidden rows, columns and sheets, and charts outside the print area.
- Estimated page count Per sheet and per workbook, clearly marked as an estimate.
Applications
Use Cases
- Before printing a long report or exporting a workbook to PDF
- Finding out why a sheet prints on 40 pages instead of 4
- Checking that a template has a print area, header rows and the right paper size
- Making sure hidden sheets and ranges are not expected in a printout
- Reviewing a workbook received from someone else before you print it
Good to Know
Limitations
The result is a diagnosis of stored print settings. Page counts are estimates; Excel may paginate differently because of the printer driver, fonts and automatically sized rows. A workbook that passes can still print wrongly on a printer whose margins or driver differ, and the checks do not look at the content of cells, formulas, fonts or colours.
Nothing is calculated or changed, macros in an .xlsm file are not run, and printer-specific settings stored in the file are ignored.
This tool runs entirely in your browser — your file is never uploaded to our servers. See our Privacy Policy for full details.
Support
Frequently Asked Questions
Is my workbook uploaded?
No. It is opened and read in your browser and is not sent to our server or elsewhere.
Why does my sheet print on so many pages?
Usually no print area is set, so Excel prints the whole used range, or the scale is 100% on a wide sheet so columns spill onto extra pages. The checker names the cause and the setting to change.
Is the page count exact?
No, it is an estimate from the stored column widths, row heights, scale and paper size. Excel decides the real pagination using your printer driver and fonts.
Why are hidden sheets not counted?
Excel skips hidden and very hidden sheets when it prints the workbook, so they add no pages. They are listed so you know they exist.
Does it change my file?
No. It is a preflight and diagnostic only; use Excel to apply the suggested settings.
What do PASS, WARNING and FAIL mean?
FAIL means a setting would give a blank, cut-off, unreadable or very long printout. WARNING means something probably looks wrong but printing works. PASS means none of the checks found a problem; the page count remains an estimate.
Keep Going
Related Tools
- PDF Page Size Analyzer List the width, height, orientation and paper size of every page in a PDF, and see whether the sizes are mixed.
- Office Document Inspector & Metadata Remover Remove metadata from Word, Excel and PowerPoint files: see author names, comments, tracked-change authors, hidden sheets and speaker notes first, then clean a copy. In your browser.
- Office Embedded Object & Macro Risk Scanner Inspect a Word, Excel or PowerPoint file for VBA macros, ActiveX, OLE objects, embedded files, external links and templates, with severity and plain explanations. A structural scan, not an antivirus. In your browser.
- Send-Safe Document Checker Before you send a confidential PDF, Word, Excel or PowerPoint file: one overview of hidden information such as metadata, comments, tracked changes, hidden sheets, notes, attachments, scripts and macros, and which tool to use next. In your browser.