Why is the print preview not working
Tutor 5 (36 Reviews)
Excel Tutor
Still stuck with a Excel question
Ask this expertAnswer
Print preview stops working when Excel cannot render the page layout, the printer configuration fails, or the worksheet settings block the preview.
Common Reasons Print Preview Fails
1. Incorrect or Missing Default Printer
Print preview depends on a valid printer driver. Excel loads the printer driver to generate the preview window.
-
A missing default printer prevents the preview from opening.
-
A corrupted printer driver blocks Excel from reading page settings.
2. Page Layout Rendering Issues
Excel switches to Page Layout View during print preview. A worksheet with damaged layout settings triggers the failure.
-
Broken margins create rendering errors.
-
Invalid paper sizes force Excel to cancel the preview.
3. Corrupted Excel Settings
Excel stores printer and display preferences in cached files. Corrupted cache data blocks preview generation.
4. Freeze Panes and Hidden Columns Affect Layout
Excel miscalculates the printable width when hidden columns or freeze panes distort the page width.
-
A worksheet that exceeds the page boundary may fail to generate a preview.
5. Add-Ins and Background Processes
Add-ins intercept print commands and disrupt the preview engine.
6. Outdated Display or Graphics Drivers
Print preview uses display rendering. Outdated GPU drivers cause the preview window to show a blank page.
7. Page Break View Errors
Manual page breaks that overlap or exceed printable regions trigger preview failure.
How to fix print preview not working
To fix print preview in Excel:
1. Set a Default Printer
-
Open the system settings.
-
Select Devices.
-
Choose Printers & Scanners.
-
Select a physical or virtual printer as the default.
2. Update or Reinstall Printer Drivers
-
Open the device manager.
-
Expand Print queues.
-
Right-click the printer and update the driver.
-
Restart Excel.
3. Reset Page Layout
-
Open the worksheet.
-
Select Page Layout.
-
Click Margins and choose Normal.
-
Select Size and set Letter or A4.
-
Remove manual page breaks through Page Break Preview.
4. Clear Excel’s Cached Settings
Windows:
-
Close Excel.
-
Open Run and enter
%appdata%\Microsoft\Excel. -
Delete the
Excel15.xlbor similar toolbar file. -
Reopen Excel.
MacBook:
-
Close Excel.
-
Go to
~/Library/Preferences/. -
Delete
com.microsoft.Excel.plist. -
Restart Excel.
5. Disable Add-Ins
-
Go to File → Options.
-
Select Add-ins.
-
Choose COM Add-ins.
-
Uncheck all add-ins.
-
Restart Excel.
6. Fix Hidden Columns and Freeze Panes
-
Select the whole sheet.
-
Right-click columns and choose Unhide.
-
Go to View → Freeze Panes → Unfreeze Panes.
7. Refresh Graphics Drivers
-
Open the device manager.
-
Expand Display adapters.
-
Update the graphics driver.
-
Restart the system.
Windows vs MacBook Differences
| Action | Windows | MacBook |
|---|---|---|
| Reset printer system | Controlled through “Printers & Scanners” | Printer system reset required through “System Settings → Printers” |
| Clear Excel settings | Delete .xlb files |
Delete plist files |
| Printer driver management | Full driver control in Device Manager | Drivers update through macOS system updates |
When print preview always shows a blank page
Print preview shows a blank page when Excel cannot match the worksheet width with the printable area.
Fix:
-
Select Page Layout.
-
Choose Scaling → Fit Sheet on One Page.
When print preview freezes Excel
Print preview freezes when the printer driver fails or the workbook has corrupted layout elements.
Fix:
-
Change the default printer to Microsoft Print to PDF.
-
Restart Excel.
-
Reopen print preview.
If you want, I can analyze your specific workbook layout and tell you the exact cause based on your file structure or settings.
. Was this Helpful?Get Online Tutoring or Questions answered by Experts.
You can post a question for a tutor or set up a tutoring session
Answers · 1
Why are margins not working
Answers · 1
Why is page layout not working
Answers · 1
How to print repeated rows on top in excel
Answers · 1
How to print header on each page
Answers · 1