Forum Discussion
Excel Print Preview not matching the actual printed document
Hey there,
My Excel print preview and printer seem to be out of sync.
I keep my excel worksheets in "Page Layout" mode when I work, I find it best when I plan to print the document in the end. In the last 2 weeks, none of the documents I've printed are coming out the way they appear on the workbook.
I have a workbook that should be 23 pages but it prints 26 instead. The rows are extending over into other pages.
Please help!!
I played only with PDF files, if you uncheck this setting
it works correctly. Attached are two PDF:s, with and without scale setting.
- Hello,
One your data is in the Page Layout mode:
1. Click on the Page Layout tab
2. Select Margins drop-down and choose Custom Margins
3. Check the Center on page Horizontally and click OK
4. Select Landscape from the Orientation drop-down
5. Adjust the Scale percentage to around 70-80%.
Your data should be fine...
Ensure you select the connected printer- Abiola1
Thanks, but I've done all that already. I always use custom margins because I have headers and footers. My pages are centred horizontally and vertically at all time. And the page is set to automatically fit all columns onto one page.
I've tried changing ALL the standard page setup settings, and the printer settings.
I've also tried manually adjusting the columns to fit the way I need (this took over an hour).
Try to check printer driver as well - you print on your default printer; paper size in Excel is the same as default in printer driver; Microsoft Print to PDF driver works properly or not.
- Thanks Sergei, but I've literally tried all the obvious and a series of not so obvious things. Nothing is working.
Perhaps you may share the file to check if replace any sensitive information with dummy values.
- Thank Broo!!!!! It helped me a lot
- Have anyone face this before :-
Text is justified and presented nicely during Pagebreak preview, however, during print preview, all text just run out from the margin.
