Number of pages printed is more than what is stated in print preview

%3CLINGO-SUB%20id%3D%22lingo-sub-2873141%22%20slang%3D%22en-US%22%3ENumber%20of%20pages%20printed%20is%20more%20than%20what%20is%20stated%20in%20print%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2873141%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20job%20requires%20me%20to%20print%20Excel%20sheets%20but%20for%20some%20reason%20certain%20pages%20are%20not%20printing%20as%20they%20are%20shown%20in%20print%20preview.%20Print%20preview%20states%20that%20my%20document%20will%20be%20printed%20as%20one%20page%20but%20the%20actual%20printed%20document%20comes%20out%20on%20two%20pages.%20Even%20more%20infuriating%2C%20it%20cuts%20off%20the%20very%20final%200.5cm%20of%20the%20document%20and%20the%20remaining%200.5cm%20shows%20up%20on%20a%20second%20page.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20hiding%20and%20deleting%20rows%2C%20adjusting%20margins%2C%20page%20breaks%2C%20etc.%20but%20they%20haven't%20solved%20my%20problem.%20If%20anyone%20knows%20how%20I%20can%20get%20my%20documents%20printed%20on%20one%20page%20with%20the%20margins%20I%20want%20that%20would%20be%20great.%26nbsp%3BWhen%20I%20tried%20printing%20the%20same%20exact%20document%20with%20the%20same%20exact%20settings%20from%20my%20colleagues'%20PCs%20and%20on%20different%20printers%2C%20there%20doesn't%20seem%20to%20be%20an%20issue.%20Just%20mine.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2873141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi everyone

 

My job requires me to print Excel sheets but for some reason certain pages are not printing as they are shown in print preview. Print preview states that my document will be printed as one page but the actual printed document comes out on two pages. Even more infuriating, it cuts off the very final 0.5cm of the document and the remaining 0.5cm shows up on a second page. 

I have tried hiding and deleting rows, adjusting margins, page breaks, etc. but they haven't solved my problem. If anyone knows how I can get my documents printed on one page with the margins I want that would be great. When I tried printing the same exact document with the same exact settings from my colleagues' PCs and on different printers, there doesn't seem to be an issue. Just mine. 

1 Reply

@ldg1903 

Without an inserted file (with no sensitive data) to repeat the problem, it is difficult for a layperson like me to identify the focus of the problem. That is why I am sending you these suggested solutions that you could try out or help you further.

 

Suggested solution 1:

Set or clear a print area on a worksheet

If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection.

 

Suggested solution 2:

In the settings of Excel it is possible to adapt the page view as reading mode, web and print layout. The print layout is the side view, which itself serves as the print view. As the document can be seen with the text and the complete formatting (page breaks and margins), it is then printed.

Switch to full or normal screen view in Excel

Preview worksheet pages before you print

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

Was the answer useful? Mark them as helpful!

This will help all forum participants.