Tweaking.com Support Forums
Main Forum => General Computer Support => Topic started by: Oscar 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
-
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
-
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.
-
So it happens on any program that has print preview, and it is just happening on the one machine?
Shane
-
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
-
Could be a printer driver. At least from what I have researched it can be one of the causes.
Shane