Windows 7 / Office 2010 print preview

[Oscar]

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

[Shane]

Found a few things

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

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

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

[Oscar]

Found a few things

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

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

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.

[Shane]

So it happens on any program that has print preview, and it is just happening on the one machine?

Shane

[Oscar]

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

[Shane]

Could be a printer driver. At least from what I have researched it can be one of the causes.

Shane