Print Preview problems

[Mgreencornerstone]

I am having print preview problems; the print preview does not correspond to the normal view. The print preview also changes when you zoom in. I am not sure which of the 3 views it the one that is going to print. The print preview is the one which normally prints but not always. Can someone help me so that I can get my spreadsheets right. I am running Office XP.

 

[BrianB]

Excel is sometimes quite bad in this respect. It tends to not like sheet or printpreview zooms of other than 100%.

A big factor in this is the printer driver you are using - nothing to do with Excel. The first thing to do is make sure that you are using the latest version of the driver from the printer manufacturer website. The fact that they need to be updated from time to time shows that these are not perfect.

Sometimes better results can be obtained by setting up your printer (like a new printer) to use a "generic" (not specific to a particular model number) printer driver eg. 'HP Laserjet' will run most laser printers.