
Your spreadsheet looks perfect on screen, then the printer cuts off the last column, splits a table across two pages, or shrinks everything to tiny print. When excel page layout printing problem strikes, the sheet itself is rarely broken. The fault is almost always in the print settings: the print area, the scaling, the page breaks, the margins, or the paper size. Excel remembers these settings with the workbook, so a setting chosen months ago can still spoil every printout today.
This guide works through the causes in order, from a quick preview check to a full Office repair. Nothing here changes your data, and every fix can be undone. Work through the fixes one at a time, and check Print Preview after each one. A preview that looks right is the proof that counts, so do not print a full run until the preview is clean.
Table of Contents
- Why This Error Happens
- Quick Checks
- Diagnosing the Problem
- Fix 1: Check Print Preview and the Printer Choice First
- Fix 2: Set the Print Area to Only the Cells You Need
- Fix 3: Clear an Old Print Area That No Longer Matches the Data
- Fix 4: Fit the Sheet to the Page With Scale to Fit
- Fix 5: Match Orientation and Paper Size to the Loaded Paper
- Fix 6: Adjust Margins and Centre the Printout on the Page
- Fix 7: Fix Manual Page Breaks That Split the Sheet in the Wrong Place
- Fix 8: Repeat Heading Rows and Columns on Every Printed Page
- Fix 9: Stop Columns Being Cut Off by Widening Columns and Wrapping Text
- Fix 10: Choose the Page Order for Sheets That Span Several Pages
- Fix 11: Control Gridlines, Row Headings and Comments on the Printout
- Fix 12: Check Hidden Rows, Columns and Sheets Before You Print
- Fix 13: Check the Printer, Paper Tray and Printer Driver
- Fix 14: Test With a PDF Printout and a Fresh Copy of the Workbook
- Fix 15: Update Excel and Repair the Office Installation
- What to Avoid
- Frequently Asked Questions
- Conclusion
- Helpful Official Resources
Why This Error Happens
Excel prints what the page setup tells it to print, not what you see on screen. The screen shows the whole grid, while the printer works page by page, inside margins, at a set scale, on a set paper size. When any of those settings disagree with the sheet or with the printer, the printout comes out wrong. These are the reasons that happens most often.
1. The Print Area No Longer Matches the Data
A print area tells Excel to print only a chosen range of cells. If someone set a print area when the sheet was smaller, new rows and columns fall outside it and never print. If the print area is too wide, Excel splits it across pages. The print area is saved with the workbook, so it survives closing and reopening, and it keeps affecting every printout until someone clears or resets it.
2. The Sheet Is Wider Than the Paper
A sheet with many columns is wider than one page at full size, so Excel must either shrink it, split it, or cut it off. With no scaling set, Excel splits the sheet at the paper edge, and the last column lands on a second page or disappears. This is the classic cause of excel page layout printing problem on wide reports, and it is also the cause that the Scale to Fit setting in Fix 4 is designed to correct.
3. Manual Page Breaks Split Rows and Columns
Page breaks tell Excel where one printed page ends and the next begins. A manual break placed for an older version of the sheet can cut straight through a table, a chart, or a block of totals. Breaks are easy to add by accident and hard to spot on the normal sheet view, because they only show clearly in Page Break Preview. One stray break can spoil an otherwise clean layout.
4. Margins, Orientation and Paper Size Disagree With the Printer
Wide margins shrink the printable area, so less of the sheet fits on each page. Portrait orientation on a wide sheet wastes space, while landscape on a narrow sheet leaves the printout small and lost. If Excel expects A4 but the tray holds Letter, or the other way round, the layout shifts and edges get cut. All three settings must match the paper that is actually loaded.
5. Scaling and Print Titles Were Never Set
Without scaling, Excel prints at 100 percent and lets pages fall where they fall. Without print titles, heading rows print only on the first page, so later pages are columns of numbers with no labels. Neither setting is automatic: Excel leaves them at their defaults unless someone sets them. A sheet that was built for the screen, with no print settings at all, is the most common source of messy printouts.
6. The Printer Driver or the Workbook File Is Damaged
The printer driver translates Excel’s layout into instructions the printer understands. An outdated or damaged driver can misread margins, paper size, or scaling, and produce a printout that matches neither the preview nor the settings. Separately, a workbook file with damaged page-setup data can carry broken layout settings from PC to PC. Both cases need the driver and file checks in Fixes 13 to 15, because no setting change fixes a broken driver or a damaged file.
Quick Checks
Two minutes before the deep fixes.
- Open Print Preview with Ctrl + P and look at every page before changing anything.
- Check the printer name at the top of the print screen is the printer you mean to use.
- Check whether the sheet printed correctly before, and what changed since — new columns, a new printer, or a shared file.
- Check whether the fault affects one sheet or the whole workbook.
- Check the paper size and orientation shown in the print settings against the paper in the tray.
- Think about what changed — did excel page layout printing problem begin after someone else edited the file, or after a printer change?
Diagnosing the Problem
| Symptom | Cause | Go to Fix |
|---|---|---|
| Last column missing or on a second page | Sheet wider than the paper | Fix 4 |
| Only part of the sheet prints | Old print area still set | Fix 3 |
| Table splits across two pages | Manual page break in the wrong place | Fix 7 |
| Printout is tiny and hard to read | Scaling set too small | Fix 4 |
| Headings missing after the first page | No print titles set | Fix 8 |
| Edges cut off on every page | Margins or paper size mismatch | Fix 6 |
| Rows or columns missing from the printout | Hidden rows, columns or sheets | Fix 12 |
| Preview looks right but the paper printout is wrong | Printer driver or paper tray fault | Fix 13 |
Fix 1: Check Print Preview and the Printer Choice First
Print Preview is the fastest diagnosis there is. It shows every page exactly as Excel plans to print it, including page breaks, scaling, and margins. Many layout faults turn out to be a wrong printer choice: Excel keeps separate settings per printer, so switching printers can change the layout. Check the preview and the printer before touching any setting.

- Open the workbook and select the sheet that prints badly.
- Press Ctrl + P to open the print screen and the preview.
- Check the printer name at the top, and change it if it is not the printer you mean to use.
- Use the page arrows under the preview to look at every page, not just the first.
- Note exactly what is wrong: cut-off columns, split tables, tiny print, or missing headings.
- Click the back arrow to return to the sheet without printing anything.
- Use your notes and the diagnosis table above to pick the next fix.
- Do not print a full run to test a setting — the preview is free, and paper is not.
- If the preview looks correct but the paper printout is wrong, skip ahead to Fix 13, because the fault is in the printer, not in Excel.
- If the preview shows only part of the sheet, the print area is the likely cause, and Fix 2 or Fix 3 will correct it.
- A preview check takes one minute and prevents the most common mistake: changing settings for a fault that lives somewhere else entirely.
Fix 2: Set the Print Area to Only the Cells You Need
The print area is the range Excel prints. Setting it to exactly the cells you need stops Excel printing empty columns, stray formatting, or forgotten notes far from the data. It also stops the sheet sprawling across extra pages. Set the print area on each sheet that prints badly, because the setting is stored per sheet.
- Select the exact range of cells you want to print, including headings and totals.
- Open the Page Layout tab on the ribbon.
- In the Page Setup group, click Print Area.
- Click Set Print Area in the drop-down list.
- Press Ctrl + P and check the preview shows only the chosen range.
- If the range is still too wide for one page, keep the print area and move to Fix 4 for scaling.
- Save the workbook so the print area is stored with the file.
- The print area is saved with the workbook, so it applies on every PC that opens the file.
- Do not include whole columns or whole rows in the print area — select only the cells with content, or Excel will try to print thousands of empty cells.
- If you add data later, the print area does not grow on its own, so reset it after adding rows or columns.
- When excel page layout printing problem means extra blank pages, a print area that covers only the real data usually ends it at once.
Fix 3: Clear an Old Print Area That No Longer Matches the Data
An old print area is invisible on the normal sheet view, and it silently limits every printout to a range chosen long ago. If part of the sheet never prints, or if new data is missing from the printout, clearing the print area and starting fresh is the right move. Clearing it restores printing of the whole used range of the sheet.
- Select the sheet that prints only part of its data.
- Open the Page Layout tab on the ribbon.
- In the Page Setup group, click Print Area.
- Click Clear Print Area in the drop-down list.
- Press Ctrl + P and check the preview now shows the full sheet.
- If the full sheet is too wide, set a fresh print area with Fix 2, or scale it with Fix 4.
- Save the workbook so the cleared setting is stored with the file.
- Clearing the print area deletes no data — it only removes the printing limit.
- Check every sheet in the workbook, because each sheet has its own print area, and a stale one on another sheet will spoil that sheet’s printout.
- If the sheet still prints only part of its data after clearing, check for hidden rows and columns in Fix 12.
- Shared workbooks are the usual source of stale print areas: someone set one for their own print run, saved the file, and never cleared it.
Fix 4: Fit the Sheet to the Page With Scale to Fit
Scale to Fit shrinks or stretches the sheet to fill a set number of pages. Setting it to one page wide stops columns spilling onto a second page, and it is the single most useful print setting for wide sheets. Use “one page wide” with “tall” left at automatic, so Excel shrinks the width but lets the length run to as many pages as it needs.
- Open the Page Layout tab and find the Scale to Fit group.
- Set Width to 1 page.
- Leave Height set to Automatic, so the sheet can use as many pages long as it needs.
- Check the Scale percentage that Excel calculates — if it falls below about 60 percent, the print will be hard to read.
- Press Ctrl + P and check the preview: all columns should now fit on each page.
- If the text is too small, switch to landscape with Fix 5, or split the sheet, rather than forcing a tiny scale.
- Save the workbook so the scaling is stored with the file.
- Never set both Width and Height to 1 page on a long sheet — Excel will shrink everything, including a hundred rows, onto a single unreadable page.
- Scale to Fit overrides the manual scale percentage, so changing the percentage afterwards has no effect until you clear the fit settings.
- If the preview still splits columns, check for manual page breaks in Fix 7, because a manual break overrides the fit.
- For a sheet that must stay readable, landscape plus one page wide is the combination that works most often.
Fix 5: Match Orientation and Paper Size to the Loaded Paper
Orientation and paper size must match both the sheet and the paper in the tray. A wide sheet needs landscape; a long narrow list needs portrait. If Excel is set to A4 while the tray holds Letter, the layout shifts by the size difference, and edges get cut. Check both settings on the Page Layout tab, and check the tray itself.
- Open the Page Layout tab and look at Orientation in the Page Setup group.
- Choose Landscape if the sheet is wider than it is tall, or Portrait if it is taller than it is wide.
- Click Size in the same group and check the paper size matches the paper loaded in the printer.
- If the tray holds a different size, change the paper in the tray, or change the setting to match the tray — never leave them different.
- Press Ctrl + P and check the preview fills the page sensibly in the new orientation.
- If the sheet still spills, combine the new orientation with Scale to Fit from Fix 4.
- Save the workbook so the orientation and size are stored with the file.
- Orientation is stored per sheet, so check each sheet that prints badly, not just the first one.
- Letter and A4 look alike but differ enough to cut off an edge, so confirm the size instead of guessing.
- Some printers have more than one tray with different paper — check the print screen shows the tray you mean to use.
- When excel page layout printing problem appears only on one printer, a paper-size mismatch between Excel and that printer’s tray is the first thing to check.
Fix 6: Adjust Margins and Centre the Printout on the Page
Margins are the blank borders around the printed area. Wide margins shrink the space for the sheet, and narrow margins risk the printer’s unprintable edge. Centring places the printout in the middle of the page instead of hugging the top-left corner. The combination of sensible margins and centring makes most printouts look clean at once.

- Open the Page Layout tab and click Margins in the Page Setup group.
- Choose Normal to start from a known-good setting, or Narrow if the sheet needs more room.
- For exact control, click Custom Margins, set the four margins, and click OK.
- In the same Page Setup dialog, open the Margins tab and tick Center on page: Horizontally.
- Tick Vertically as well if the sheet is short and you want it centred top to bottom.
- Press Ctrl + P and check the preview sits evenly on the page with no cut edges.
- Save the workbook so the margins are stored with the file.
- Do not set margins to zero — every printer has an unprintable border, and content in that border is cut off.
- Custom margins survive with the workbook, so a margin set for one printer can look wrong on another; recheck them after a printer change.
- Header and footer margins are separate from page margins, so if headers are cut off, check the header and footer distances in the same dialog.
- Narrow margins plus Scale to Fit is the pair that rescues most wide sheets without shrinking the text too far.
Fix 7: Fix Manual Page Breaks That Split the Sheet in the Wrong Place
Manual page breaks force a new page at a chosen row or column. They are useful when placed deliberately, and destructive when left over from an older layout. Page Break Preview shows every break as a thick blue line, and lets you drag breaks to sensible places or remove them entirely. Use it whenever a table splits in the middle.
- Open the View tab and click Page Break Preview.
- Look for thick blue lines crossing the sheet — each one is a page break.
- Drag a break line to a gap between tables or sections, so no table is split.
- To remove a break, right-click the row or column next to it and choose Remove Page Break.
- To remove all manual breaks at once, right-click any cell and choose Reset All Page Breaks.
- Return to Normal view from the View tab, then press Ctrl + P to check the preview.
- Save the workbook so the corrected breaks are stored with the file.
- Automatic breaks appear as dashed lines and move on their own when settings change — only the solid manual breaks need your attention.
- A break through the middle of a chart or a merged title row is the most visible sign of a stray manual break.
- Resetting all breaks is safe: Excel recreates automatic breaks at sensible places, and you can add manual ones back where you want them.
- Check Page Break Preview again after changing scaling or orientation, because those changes move the automatic breaks.
Fix 8: Repeat Heading Rows and Columns on Every Printed Page
Print titles repeat chosen rows or columns on every printed page. Without them, page two onwards is a wall of numbers with no headings, and readers cannot tell which column is which. Set the heading row as a print title on every sheet that runs to more than one page, and set a heading column too if the sheet runs wide.
- Open the Page Layout tab and click Print Titles in the Page Setup group.
- In the Sheet tab of the dialog, click the Rows to repeat at top box.
- Click the heading row on the sheet itself — Excel fills in the row reference for you.
- If the sheet runs across pages, click the Columns to repeat at left box and click the heading column.
- Click OK, then press Ctrl + P and page through the preview.
- Check that the headings appear at the top of every page, not just the first.
- Save the workbook so the print titles are stored with the file.
- Print titles do not change the sheet on screen — they only affect printing, so the sheet looks the same in Normal view.
- Do not include the whole data range as a print title, or every page will repeat the same block and waste paper.
- If the heading row is hidden or filtered, the repeated title may print blank, so unhide the heading row first.
- Print titles and frozen panes are separate features: freezing panes helps on screen, while print titles help on paper, and a sheet that needs one usually needs both.
Fix 9: Stop Columns Being Cut Off by Widening Columns and Wrapping Text
Columns print at the width they have on screen. A column that shows its content on screen only because neighbouring cells are empty will still print cut off, because the printer respects cell boundaries strictly. Widening columns, wrapping text, and shrinking text to fit are the three controls that stop cut-off text, and they work best together.
- Select the columns whose content is cut off in the preview.
- Double-click a column border in the column headings to auto-fit the width to the longest entry.
- If a column is still too narrow, select its cells, open Format Cells, and tick Wrap text on the Alignment tab.
- For short labels that must stay on one line, tick Shrink to fit instead of wrapping.
- Check row heights after wrapping — wrapped text needs taller rows, and Excel usually adjusts them on its own.
- Press Ctrl + P and check that every column’s content is fully visible on the page.
- Save the workbook so the column widths are stored with the file.
- Merged cells do not auto-fit, so a merged title that is cut off needs its width set by hand.
- Numbers that show as
###mean the column is too narrow for the number format — widen the column rather than changing the format. - The same cut-off pattern appears in Word documents, and our guide to Microsoft Word printing cut-off text covers the Word side of the fault.
- When excel page layout printing problem means cut-off text on one column only, that column’s width is the cause, and no page setting will fix it.
Fix 10: Choose the Page Order for Sheets That Span Several Pages
When a sheet spans several pages both across and down, Excel must choose the order: down then over, or over then down. The wrong order makes a printed report read strangely, with the reader jumping across the sheet instead of down it. The right order depends on how the sheet is read, and the setting lives on the Sheet tab of Page Setup.

- Open the Page Layout tab and click the small dialog launcher arrow in the Page Setup group.
- In the Page Setup dialog, open the Sheet tab.
- Find the Page order section near the bottom of the tab.
- Choose Down, then over if the sheet reads top to bottom, which suits most reports.
- Choose Over, then down if the sheet reads left to right across wide tables.
- Click OK, then press Ctrl + P and page through the preview in order.
- Save the workbook so the page order is stored with the file.
- Page order only matters when the sheet spans pages in both directions — a sheet that fits one page wide is unaffected.
- Number the pages with a footer page number, so readers can reassemble a multi-page printout in the right order whatever the setting.
- If the sheet spans many pages across, consider splitting it into separate print areas or separate sheets instead of relying on page order.
- The preview pages follow the chosen order, so paging through the preview is the reliable test — do not trust the on-screen grid.
Fix 11: Control Gridlines, Row Headings and Comments on the Printout
Excel can print gridlines, row and column headings, comments, and error values, or leave them all off. The defaults suit most sheets, but a sheet with gridlines switched on prints a heavy grid over everything, and a sheet with comments set to print adds extra pages. The Sheet tab of Page Setup holds all of these switches in one place, so check them together.
- Open the Page Layout tab and click the dialog launcher arrow in the Page Setup group.
- In the Page Setup dialog, open the Sheet tab.
- Under Print, untick Gridlines unless you genuinely want the grid on paper.
- Untick Row and column headings unless the printout needs the A, B, C and 1, 2, 3 labels.
- Set Comments to (None) unless the comments themselves must print.
- Set Cell errors as to <blank> if error values are cluttering the printout.
- Click OK, then press Ctrl + P and check the preview is clean.
- Gridlines on screen and gridlines on paper are separate switches — turning off the screen gridlines does not change the print setting.
- Charts and pictures print by default; if an object is missing from the printout, check its properties rather than these switches.
- Comments set to print at the end of the sheet add pages that look like errors, so check this switch when extra pages appear.
- A clean printout usually means gridlines off, headings off, comments off, and the sheet’s own borders doing the visual work.
Fix 12: Check Hidden Rows, Columns and Sheets Before You Print
Hidden rows and columns do not print, and hidden sheets do not print at all. A sheet that looks complete on screen can print with gaps, because the hidden parts are skipped silently. Filters have a similar effect: filtered-out rows do not print. Unhide and clear filters before printing, or accept the gaps knowingly.
- Select the whole sheet by clicking the corner box above row 1 and left of column A.
- Right-click a row heading and choose Unhide, then right-click a column heading and choose Unhide.
- Look for gaps in the row numbers or column letters, which mark rows or columns still hidden.
- Right-click a sheet tab and choose Unhide to see whether any sheet is hidden.
- Open the Data tab and click Clear in the Sort & Filter group to remove any active filter.
- Press Ctrl + P and check the preview now shows the full sheet with no unexplained gaps.
- Re-hide anything you want hidden on screen, knowing it will not print, then save the workbook.
- Grouped and outlined rows can be collapsed as well as hidden — look for the small plus and minus buttons at the edge of the sheet.
- Very hidden sheets, set through the Visual Basic editor, do not appear in the Unhide list, so ask the file’s author if a sheet seems to be missing.
- Filtering is the most common cause of “missing rows” in printouts, because the filter arrows are easy to overlook.
- If the gaps persist after unhiding, check the print area in Fix 3, because a stale print area skips cells in the same silent way.
Fix 13: Check the Printer, Paper Tray and Printer Driver
When the preview looks right but the paper printout is wrong, the fault is past Excel: in the printer, the paper, or the driver. A tray set to the wrong paper size overrides Excel’s setting, an outdated driver misreads the layout, and a printer with its own scaling setting can shrink or stretch the page. Check the hardware side before blaming the workbook.

- Open the paper tray and confirm the loaded paper matches the size set in Excel.
- Check the tray guides hug the paper snugly, with no gap and no bend.
- Print a test page from the printer’s own menu or from Windows printer settings.
- If the test page is also wrong, the fault is in the printer or its driver, not in Excel.
- Open Settings, then Bluetooth & devices, then Printers & scanners, and open your printer.
- Check for a driver update from the printer maker’s website, and install it if one is offered.
- Print one test page from Excel and compare it with the preview.
- A printer’s own “fit to page” or scaling setting can fight Excel’s scaling — turn the printer’s scaling off and let Excel control the layout.
- If Windows cannot see the printer at all, our guide to Windows 11 printer not detected covers the detection side of the fault.
- Wireless printers sometimes fall back to default settings after a connection drop, so recheck the paper size after reconnecting.
- When excel page layout printing problem affects only one printer in the office, the driver and tray on that printer are the cause, and the workbook is innocent.
Fix 14: Test With a PDF Printout and a Fresh Copy of the Workbook
Printing to PDF removes the physical printer from the chain. If the PDF looks right, the workbook and its settings are fine, and the printer is at fault. If the PDF looks wrong too, the fault is in the workbook, and copying the data into a fresh workbook strips out any damaged page-setup data. The two tests together pin the fault down exactly.
- Press Ctrl + P and change the printer to Microsoft Print to PDF.
- Click Print, save the PDF, and open it to check every page.
- If the PDF looks correct, return to Fix 13 — the physical printer or its driver is the fault.
- If the PDF looks wrong, create a new blank workbook.
- Copy the data from the old sheet with Paste Special and Values, then reapply formatting simply.
- Set the print area, scaling, and margins fresh on the new workbook, using Fixes 2 to 6.
- Print the new workbook to PDF and check the layout is clean.
- Paste Special with Values leaves behind any damaged formatting or page-setup data, which is the point of the fresh copy.
- If the original workbook will not open at all, our guide to Excel file not opening covers the recovery steps.
- Keep the original file untouched until the fresh copy prints correctly, so nothing is lost if the copy misses a sheet.
- A fresh copy that prints cleanly proves the old file carried damaged settings, and the new file becomes the master copy from then on.
Fix 15: Update Excel and Repair the Office Installation
An outdated Excel can carry printing bugs that updates have already fixed, and a damaged Office installation can misbehave in ways no setting change corrects. Updating is quick and safe, and the Online Repair reinstalls Office files while keeping your documents and settings. Use this fix last, after the settings, printer, and file checks have all been tried.
- Open Excel, then File, then Account, and click Update Options, then Update Now.
- Wait for the update to finish, then restart Excel.
- Test the print preview again — if the layout is fixed, stop here.
- If the fault remains, open Windows Settings, then Apps, then Installed apps.
- Find Microsoft 365 or Microsoft Office, click the three dots, and choose Modify.
- Choose Online Repair, click Repair, and wait for the repair to finish.
- Restart the PC, open the workbook, and check the print preview once more.
- Online Repair needs an internet connection and can take twenty minutes or more — do not interrupt it.
- Quick Repair is faster but shallower; use Online Repair when the fault has survived every other fix.
- If other Office apps misbehave too, our guide to Office apps crashing on startup covers the wider Office repair.
- After a repair, recheck the print settings on the workbook, because the repair can reset some Excel defaults.
What to Avoid
- Do not set the scale below 60 percent to force a sheet onto one page — the printout becomes unreadable, and splitting the sheet is the honest fix.
- Do not delete columns or rows to make a sheet fit — change the layout settings instead, and keep the data intact.
- Do not print a full run before checking Print Preview — the preview is free, and a bad run wastes paper and time.
- Do not use pirated software, activators, or cracks to “fix” Excel — they can damage Office files and invite malware.
- Do not change the printer driver from an unknown download site — use the printer maker’s own website or Windows Update.
- Do not ignore the paper size in the tray — Excel and the tray must agree, or the layout shifts on every page.
- Do not save over the only copy of a workbook before testing a fresh copy — keep the original until the new file prints cleanly.
Frequently Asked Questions
Why does excel page layout printing problem keep coming back after I fix it?
Because the print settings are saved with the workbook, and opening the file on another PC or sharing it with someone else can bring the old settings back. A stale print area, an old scaling value, or a manual page break travels with the file. Fix the settings, save the file, and share the saved copy, so everyone prints from the corrected version. If the fault returns on one printer only, that printer’s driver or tray settings are overriding the file.
Why does my sheet print on two pages when it fits on one screen?
The screen and the page are different sizes. A screen shows the grid at any zoom, while a page has fixed dimensions, margins, and a printable area. A sheet that fits the screen at 80 percent zoom is wider than one page at 100 percent print scale. Scale to Fit in Fix 4 bridges the gap by shrinking the sheet to one page wide, and landscape orientation in Fix 5 gives wide sheets more room.
Should I use Scale to Fit or set the scale percentage by hand?
Use Scale to Fit for most sheets, because it adapts if you add columns or change the paper size. Set the percentage by hand only when the printout must match an exact size, such as a form or a label sheet. Note that Scale to Fit overrides the manual percentage, so the two settings cannot work together — choose one, and clear the other.
Why are my headings missing from the second page onwards?
Because Excel prints each page independently, and the heading row is only on the first page unless you set print titles. Fix 8 sets the heading row to repeat at the top of every page, and the heading column to repeat at the left of every page. This setting affects printing only, so the sheet looks unchanged on screen.
Does the print area affect other sheets in the workbook?
No. The print area, scaling, margins, orientation, and page breaks are all stored per sheet. Fixing one sheet leaves the others untouched, which is why a workbook can print one sheet perfectly and another badly. Work through the fixes sheet by sheet, and save the workbook after each sheet is corrected.
Will updating Excel change my print settings?
Updating Excel does not change the print settings stored in your workbooks, but an Office repair can reset some Excel defaults, such as the default printer or the default paper size. After an update or repair, open the workbook, check Print Preview, and confirm the settings are still as you left them. When excel page layout printing problem survives an update, the settings in the file are the cause, not the Excel version.
Conclusion
When excel page layout printing problem spoils a printout, start with Print Preview, then fix the print area, the scaling, and the page breaks, and only then look at the printer and the file. Most sheets are fixed by the first six fixes, because the fault is a setting, not damage. Finish by printing one test page and comparing it with the preview, because a test page that matches the preview is the proof the layout is truly fixed. Save the corrected workbook, and the clean layout travels with the file wherever it goes.
