Free tools Windows power users keep installed
One-click scans. No signup required.
Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
Clear the existing print-title entries, then select one uninterrupted range of complete rows or columns. For example, use $1:$2 to repeat rows 1 and 2, or $A:$C to repeat columns A through C. Excel cannot repeat separated rows or columns such as rows 1 and 3 by themselves.
The steps below apply to desktop Excel. If the fields look empty or the error returns, work through the reset and workbook-specific checks after the basic fix.
What the error means
Print titles are worksheet rows or columns Excel repeats on each printed page—for example, a table’s column labels at the top of every page. Excel expects each print-title field to contain a single continuous range made up of whole rows or whole columns.
- Contiguous means adjacent, with no gaps.
- Complete rows or columns means full worksheet rows or columns, not a cell fragment such as
A1:F1.
These are valid references:
| What to repeat | Reference |
|---|---|
| Row 1 | $1:$1 |
| Rows 1 and 2 | $1:$2 |
| Rows 3 through 5 | $3:$5 |
| Column A | $A:$A |
| Columns A through C | $A:$C |
These are not valid as print-title ranges:
$1:$1,$3:$3— two separated row ranges.$A:$A,$C:$C— two separated column ranges.A1:F1— cells in part of a row, not the complete row.
If you need rows 1 and 3 on every page but do not want row 2, Excel’s print-title setting cannot select that combination directly. Use the continuous range $1:$3 (which also repeats row 2), rearrange the headings so they are adjacent, or make a separate print-friendly report.
Fast fix in Windows desktop Excel
- Select the affected worksheet. Make sure you are not editing a cell.
- Open Page Layout → Print Titles.
- On the Sheet tab, clear both Rows to repeat at top and Columns to repeat at left, then select OK.
- Open Page Layout → Print Titles again.
- Enter one valid range in the relevant field—for example,
$1:$2in Rows to repeat at top or$A:$Bin Columns to repeat at left. - Select OK, then open File → Print or press
Ctrl+Pto check the preview.
Microsoft documents this Page Layout/Page Setup route and the full-row references used for repeating titles. See Microsoft’s instructions for repeating rows or columns.
Selecting the range instead of typing it
- In the Print Titles dialog, select the range-selection button beside the field you want to set.
- For rows, select the row numbers along the worksheet’s left edge. For columns, select the column letters across the top.
- Drag across adjacent labels, or select the first label and use
Shiftwith the last to extend the range. - Return to the dialog and confirm the reference is a single continuous range.
Do not use Ctrl to select separated rows or columns. That creates a multiple-area selection rather than the single range the print-title setting expects.
If Print Titles is grayed out or unavailable
Check these conditions before troubleshooting the range:
Recommended Free Tools
- Several worksheets are selected: Print-title fields are unavailable for grouped worksheets. Right-click a selected sheet tab and choose Ungroup Sheets, or click a single unselected sheet tab.
- A cell is being edited: Press
EnterorEscto leave edit mode, then try again. - A chart is selected: Click a worksheet cell before opening the command.
- No printer is installed: Microsoft lists this as another condition that can disable the command. Connect or install a printer, then retry.
- You are using Excel for the web: Some repeating-title print options are not available there. Open the workbook in desktop Excel for the full page-setup controls.
For Microsoft’s list of command limitations and supported desktop versions, see Repeat specific rows or columns on every printed page.
If both fields already look blank
An empty-looking dialog does not prove every workbook print setting is healthy. User reports describe the error in files whose visible print-title fields appeared blank; stale settings or workbook-specific issues are possibilities, but Microsoft does not document one universal hidden-metadata cause. Try this low-risk sequence:
- Open Page Layout → Print Titles, confirm both fields are blank, and select OK.
- Save the workbook, close Excel, reopen the file, and test File → Print.
- If the problem remains, reopen the dialog and enter a valid full-row or full-column reference manually.
- Test printing again. If the error persists, continue with the print-area and workbook checks below.
Test the print area separately
A print area controls which cells Excel prints; it is separate from print titles, so clearing it is a diagnostic step—not a guaranteed fix for this error. If the basic reset did not help:
Rank #3
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
- Open Page Layout → Print Area → Clear Print Area.
- Check print preview again.
- If printing now works, recreate the intended print area as one clean range, then reapply the print titles.
Clearing the print area does not delete worksheet data, but it can make Excel print more of the sheet than you intended. Review the preview before printing.
Check for grouped sheets and workbook-specific problems
If only one sheet or one file fails, isolate the problem rather than changing the whole workbook at once:
- Print each worksheet separately to identify the failing sheet.
- On that sheet, confirm it is not grouped with others, then clear and recreate its print titles.
- Check and, if necessary, recreate its print area.
- If the workbook came from an export, conversion, or another application, test a copy of the data in a new worksheet or a clean workbook.
Copying data to a new workbook is a diagnostic or recovery option, not a first step. It may not carry over macros, named ranges, external links, hidden sheets, page breaks, or other workbook configuration. Keep the original file and compare the new copy before relying on it.
Some older troubleshooting reports suggest testing merged cells if ordinary fixes fail, particularly when a merged region spans multiple rows or columns. That is an anecdotal diagnostic, not a confirmed general cause. Hidden rows inside a continuous range do not by themselves make the range discontinuous.
Generated reports can also have export-specific problems. If a newly downloaded file repeatedly triggers the error, try the clean-copy test and report the issue to the system that produces the workbook; do not assume the same cause applies to every exported file.
Should you change “Cell errors as” to “<blank>”?
Some third-party guides and user reports recommend this as a secondary workaround. In Page Layout → Print Titles → Sheet, the Cell errors as setting controls how worksheet error values appear on paper. Microsoft documents options such as displaying the error, printing a blank, or using another displayed value; it does not identify this setting as the normal cause or standard fix for an invalid print-title range. See Microsoft’s Page Setup documentation.
Best Value
If you try <blank>, save the workbook and test print preview. Be aware that it can hide useful errors such as #N/A or #DIV/0! from the paper copy. For financial, audit, engineering, or quality-control reports, do not hide error values unless that output is intentional. Restore the prior setting if the workaround does not help.
Print titles, print area, headings, and headers are different
| Setting | What it does |
|---|---|
| Print titles | Repeats selected worksheet rows or columns on each printed page, such as a table’s labels. |
| Print area | Limits printing to a chosen part of the worksheet. |
| Row and column headings | Prints Excel’s built-in coordinate labels, such as 1, 2, 3 and A, B, C. |
| Headers and footers | Adds page-level text such as a report name, date, or page number. |
These settings are not interchangeable. For example, turning on the built-in row and column headings will not repeat your report’s own table headings. Microsoft explains the distinction in its row and column headings instructions and Page Setup guide.
Excel for the web, Windows, and Mac
As of September 2026, Microsoft’s support pages list the repeating-title feature for desktop Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. Excel for the web does not currently support repeating column headers when printing; open the workbook in the desktop app for that task. Web capabilities and labels can change, so check Microsoft’s current guidance if the interface differs.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteOn Mac, the path is also through Page Layout and Page Setup, though Microsoft’s Mac instructions use the tab label Sheets. See Microsoft’s instructions for Excel for Mac.
Quick Recap
Sources
- Microsoft: Repeat specific rows or columns on every printed page
- Microsoft: Print rows with column headers on top of every page
- Microsoft: Page Setup
- Microsoft: Print headings or titles on every page in Excel for Mac
- Excel Insider: troubleshooting reports on stale references and print areas
- Excel Forum: user discussion of the exact error
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
