Forum Discussion
Gano1224
Nov 25, 2019Copper Contributor
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 t...
- Nov 28, 2019
I played only with PDF files, if you uncheck this setting
it works correctly. Attached are two PDF:s, with and without scale setting.
Abiola1
Nov 25, 2019MVP
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
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
- Gano1224Nov 25, 2019Copper ContributorAbiola1
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).