Author Topic: Windows 7 / Office 2010 print preview  (Read 6855 times)

0 Members and 1 Guest are viewing this topic.

Offline Oscar

  • Full Member
  • ***
  • Join Date: Dec 2012
  • Posts: 220
  • Karma: 0
    • View Profile
Windows 7 / Office 2010 print preview
« on: March 25, 2014, 01:43:45 PM »
Hi when i use the print preview before printing anything Excel etc the format e.g margins do not print the same as what print preview indicates.

Please can you help.

Thanks in advance

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Windows 7 / Office 2010 print preview
« Reply #1 on: March 25, 2014, 02:32:09 PM »
Found a few things

Quote
In Print preview, select the Page setup button, select Margins and adjust to suit, also select Center horizontally and vertically buttons. On the Page button is the ability to scale what you want to print, either larger or smaller. What you see in preview is always an approximation, not the actual dimensions. It's an aid only, to check what will be printed.

and

Quote
Depending on the fonts you use, column widths and row heights may appear differently when you print or view a worksheet in print preview. This behavior occurs when you use proportionally spaced fonts, such as a proportional TrueType font.

This problem does not occur when you use monospace fonts (fonts with fixed widths), such as Courier New. The discrepancy in font metrics is a function of how Microsoft Windows reports the font information to Microsoft Excel.

and

http://support.microsoft.com/kb/2678993

and

Quote
Perhaps it's a combination of things:
1. You may have a Print Area set on your spreadsheet. To clear it, go to Page Layout tab > Page Setup group > Print Area > Clear Print Area.

2. You may also have your spreadsheet set to "Fit to x pages wide by y pages tall" in Page Setup. To check this, go to Page Layout tab > click small arrow in lower right corner of Page Setup group > on Page tab, select 'Adjust to' and set it to 100%.

Shane

Offline Oscar

  • Full Member
  • ***
  • Join Date: Dec 2012
  • Posts: 220
  • Karma: 0
    • View Profile
Re: Windows 7 / Office 2010 print preview
« Reply #2 on: March 27, 2014, 12:30:34 AM »
Found a few things

Quote
In Print preview, select the Page setup button, select Margins and adjust to suit, also select Center horizontally and vertically buttons. On the Page button is the ability to scale what you want to print, either larger or smaller. What you see in preview is always an approximation, not the actual dimensions. It's an aid only, to check what will be printed.

and

Quote
Depending on the fonts you use, column widths and row heights may appear differently when you print or view a worksheet in print preview. This behavior occurs when you use proportionally spaced fonts, such as a proportional TrueType font.

This problem does not occur when you use monospace fonts (fonts with fixed widths), such as Courier New. The discrepancy in font metrics is a function of how Microsoft Windows reports the font information to Microsoft Excel.

and

http://support.microsoft.com/kb/2678993

and

Quote
Perhaps it's a combination of things:
1. You may have a Print Area set on your spreadsheet. To clear it, go to Page Layout tab > Page Setup group > Print Area > Clear Print Area.

2. You may also have your spreadsheet set to "Fit to x pages wide by y pages tall" in Page Setup. To check this, go to Page Layout tab > click small arrow in lower right corner of Page Setup group > on Page tab, select 'Adjust to' and set it to 100%.

Shane

Thanks Shane

I have put it in a shared drive and my boss has printed it and came out the same as what the Print Preview indicates when printed.
This problem occurs with PDF and other files as well.


Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Windows 7 / Office 2010 print preview
« Reply #3 on: March 27, 2014, 09:30:12 AM »
So it happens on any program that has print preview, and it is just happening on the one machine?

Shane

Offline Oscar

  • Full Member
  • ***
  • Join Date: Dec 2012
  • Posts: 220
  • Karma: 0
    • View Profile
Re: Windows 7 / Office 2010 print preview
« Reply #4 on: March 28, 2014, 01:18:51 AM »
So it happens on any program that has print preview, and it is just happening on the one machine?

Shane

Thanks Shane

There is only two machines, mine and the manager (which prints fine).

Could mine be a printer driver problem?

Thanks again

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Windows 7 / Office 2010 print preview
« Reply #5 on: March 28, 2014, 10:18:06 AM »
Could be a printer driver. At least from what I have researched it can be one of the causes.

Shane