SOLVED

Excel Print Preview not matching the actual printed document

%3CLINGO-SUB%20id%3D%22lingo-sub-1030343%22%20slang%3D%22en-US%22%3EExcel%20Print%20Preview%20not%20matching%20the%20actual%20printed%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030343%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20there%2C%3C%2FP%3E%3CP%3EMy%20Excel%20print%20preview%20and%20printer%20seem%20to%20be%20out%20of%20sync.%3C%2FP%3E%3CP%3EI%20keep%20my%20excel%20worksheets%20in%20%22Page%20Layout%22%20mode%20when%20I%20work%2C%20I%20find%20it%20best%20when%20I%20plan%20to%20print%20the%20document%20in%20the%20end.%20In%20the%20last%202%20weeks%2C%20none%20of%20the%20documents%20I've%20printed%20are%20coming%20out%20the%20way%20they%20appear%20on%20the%20workbook.%3C%2FP%3E%3CP%3EI%20have%20a%20workbook%20that%20should%20be%2023%20pages%20but%20it%20prints%2026%20instead.%20The%20rows%20are%20extending%20over%20into%20other%20pages.%3C%2FP%3E%3CP%3EPlease%20help!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1030343%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eprint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPrinting%20Problem%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1030518%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Print%20Preview%20not%20matching%20the%20actual%20printed%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030518%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3EOne%20your%20data%20is%20in%20the%20Page%20Layout%20mode%3A%3CBR%20%2F%3E1.%20Click%20on%20the%20Page%20Layout%20tab%3CBR%20%2F%3E2.%20Select%20Margins%20drop-down%20and%20choose%20Custom%20Margins%3CBR%20%2F%3E3.%20Check%20the%20Center%20on%20page%20Horizontally%20and%20click%20OK%3CBR%20%2F%3E4.%20Select%20Landscape%20from%20the%20Orientation%20drop-down%3CBR%20%2F%3E5.%20Adjust%20the%20Scale%20percentage%20to%20around%2070-80%25.%3CBR%20%2F%3E%3CBR%20%2F%3EYour%20data%20should%20be%20fine...%3CBR%20%2F%3E%3CBR%20%2F%3EEnsure%20you%20select%20the%20connected%20printer%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1030634%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Print%20Preview%20not%20matching%20the%20actual%20printed%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030634%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%20but%20I've%20done%20all%20that%20already.%20I%20always%20use%20custom%20margins%20because%20I%20have%20headers%20and%20footers.%20My%20pages%20are%20centred%20horizontally%20and%20vertically%20at%20all%20time.%20And%20the%20page%20is%20set%20to%20automatically%20fit%20all%20columns%20onto%20one%20page.%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20tried%20changing%20ALL%20the%20standard%20page%20setup%20settings%2C%20and%20the%20printer%20settings.%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20also%20tried%20manually%20adjusting%20the%20columns%20to%20fit%20the%20way%20I%20need%20(this%20took%20over%20an%20hour).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1032214%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Print%20Preview%20not%20matching%20the%20actual%20printed%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1032214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F468222%22%20target%3D%22_blank%22%3E%40Gano1224%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20to%20check%20printer%20driver%20as%20well%20-%20you%20print%20on%20your%20default%20printer%3B%20paper%20size%20in%20Excel%20is%20the%20same%20as%20default%20in%20printer%20driver%3B%20Microsoft%20Print%20to%20PDF%20driver%20works%20properly%20or%20not.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1036149%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Print%20Preview%20not%20matching%20the%20actual%20printed%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1036149%22%20slang%3D%22en-US%22%3EThanks%20Sergei%2C%20but%20I've%20literally%20tried%20all%20the%20obvious%20and%20a%20series%20of%20not%20so%20obvious%20things.%20Nothing%20is%20working.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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!!

19 Replies
Highlighted
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
Highlighted
@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).
Highlighted

@Gano1224 

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.

Highlighted
Thanks Sergei, but I've literally tried all the obvious and a series of not so obvious things. Nothing is working.
Highlighted

@Gano1224 

Perhaps you may share the file to check if replace any sensitive information with dummy values.

Highlighted
Give me a couple of days. Thanks
Highlighted

@Gano1224 

Sure. I can't promise we will find something, but at least will try.

Highlighted

@Sergei Baklan 

 

Hey, I've attached an excel spreadsheet example of what I was talking about, as well as 2 PDFs to explain further.

The "Print to PDF" document shows the correct layout

The "Save as PDF" document shows how it comes out of the printer - which is a complete mess (for me)

 

I'd appreciate any insight you can give.

Highlighted
Best Response confirmed by Gano1224 (Occasional Contributor)
Solution

@Gano1224 

I played only with PDF files, if you uncheck this setting

image.png

it works correctly. Attached are two PDF:s, with and without scale setting.

Highlighted
You are my hero! Seriously!

Thanks a million.
Highlighted

@Gano1224 

Glad to help, you are welcome

Highlighted

@Sergei Baklan You legend! I have been having issues with printing to PDFs on two of nine PCs for months if not years. I was having to get other people in the office to print certain (not all) spreadsheets to PDF for me. This solved the issue for me. Thanks!

Highlighted

@ACutler , you are welcome, glad to help.

Highlighted
Thank you Sergei! This worked for me too.
Highlighted
Highlighted
You did a great job. This helps me a lot. Thank you:)
Highlighted
Highlighted

@Sergei Baklan Thanks sir, also worked for me

Highlighted