Printing result different from print preview

M

MARY4FRACK

New Member
Joined
Aug 13, 2008
Messages
3
Hello.

I have a problem when printing in excel, I hope someone can help me.

I have created a document that contains a normal table with 6 columns and some rows, I have included a title and a footer which are supposed to repeat in all pages. I have also included some rows, on the top of the document, to be repeated in all pages. I have arranged all the margins, manually, in the Print Preview window, so that everything appears correctly. Everything looks just the way I want it on the Print Preview, but when I print that same page, there is a space between the things I have written in the title and the table with the normal content. The space is about 1.5 cm. Of course, everything moves down and the footer is cut off the page and does not appear on the printed page.

I have gone over again and again on the margin configuration, and everything looks fine in the print preview, but always the result is the same. With the wierd space that appears, moving everything down.

Can anyone please tell me what is happening? What is the problem?

Thanks.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Have you tried Page Break View? And see if your print area is really what you think it is? As opposed to just the Print Preview.
 
Upvote 0
Also, in the Page Setup>Margins tab, check the size of the Headers and Footers. They should only be large enough to contain the headers and footers you have set up, and definitely no larger than their respective top and bottom margins.

Untested, but it sounds like you might have too much "header" in the Margins tab, and not enough "footer"
 
Last edited:
Upvote 0
bk said:
Have you tried Page Break View? And see if your print area is really what you think it is? As opposed to just the Print Preview.
Click to expand...

Thanks for your answer.

Yes, I can see the whole content and it´s fine. But when printing there´s an empty space that I don´t know where it comes from and I moves the rest of the content down.
 
Upvote 0
Barry Katcher said:
Mary, have you tried looking at what I suggested above?
Click to expand...

Thank you.

Yes, I tried. According to the measurement numbers and the preview, everything is fine.

I have done the "experiment" of creating a completely new document with just my name in the title or header (which would repeat in all pages) and under it a one cell with margin and some text inside it. Then I go to page preview where I move the margins so the cell will appear right underneath the header, with aprox. 2mm of space between them, and everything looks fine there, but when I print it, the result is also different; there is a much bigger space between the header (my name) and the cell. If you try this does it happen to you too?

Thank you so much for your help.
 
Upvote 0
try some of these troubleshooting videos listed below at the site. the problem is often something stupid like what view you are in and also maybe you did set the print are in a funny way and accidentally included something else.

check these out and see if they can provide some insight because it could be a multitude of issues, even an accidental, repeat row or column on the page setup.

http://www.excelishell.com/tutorials/printing/printing.php
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Right side of linked image not printing/visible
Replies
0
Views
272
BrainDiseasee
B
Y
  • Solved
Greyed Rows - print BLACK
Replies
3
Views
390
rollis13
rollis13
J
  • Question
Print Preview disorders pictures
Replies
0
Views
268
Johnssen
J
C
  • Question
Formatting issue - Space being inserted above some word wrapped cells with autofit - not the same cells as print preview
Replies
0
Views
776
CBme
C
C
  • Question
Copy a form multiple times from page break view
Replies
5
Views
318
Herakles
H

Forum statistics

Threads
1,214,950
Messages
6,122,428
Members
449,083
Latest member
Ava19

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top