Excel Shrinking Table When Printing

[family guy]

I've attached a screen shot. I have a table set to fit to one page, center horizontally and vertically. Whenever I print or go to print preview, the table shrinks. Its forgetting tab and column spacing as well (as you can see by the cut off text). Any ideas?

[celestialspring]

Have you checked your header and footer settings?

[family guy]

  celestialspring said:

Have you checked your header and footer settings?

Checked them now. There are no headers or footers. Margins are set to 0.75" Top & Bottom, 0.70" Left & Right, 0.30" Header & Footer

[celestialspring]

Can you then please upload the xlsx file for me to look at?

[AbandonedTrolley]

Have you checked that the 'print area' is set correctly and not printing empty cells to the sides and below?

[family guy]

  celestialspring said:

Can you then please upload the xlsx file for me to look at?

Attached. Its zipped because the forum said I can't upload an xlsx.

  AbandonedTrolley said:

Have you checked that the 'print area' is set correctly and not printing empty cells to the sides and below?

Yes, I even tried setting again just now.

Excel.zipFetching info...

[AbandonedTrolley]

  family guy said:

Attached. Its zipped because the forum said I can't upload an xlsx.

Yes, I even tried setting again just now.

Strange all looks fine here on Excel 2002, must be a local setting i'm guessing.

[Guest]

Print preview works fine for me in '07.

What's your page setup like? This can be found from the print preview screen.

[celestialspring]

The file prints fine on my end.

A few things to try:

1. Try printing the file to a pdf printer. See if it still has the same problem.

2. Try saving the as PDF. File-->Save As-->PDF or XPS , see if the problem persists.

From what I can understand now is that there is a problem in the specific printer you are using? Is everything else printing correctly?

[I8PP]

Just a guess, but it looks like the printer has been set to print 4 sheets per page.

[celestialspring]

  I8PP said:

Just a guess, but it looks like the printer has been set to print 4 sheets per page.

Bulls eye I8PP

I also think that is the problem...

[family guy]

  Harreh said:

Print preview works fine for me in '07.

What's your page setup like? This can be found from the print preview screen.

Attached screen shot. Looks all normal to me.

  celestialspring said:

The file prints fine on my end.

A few things to try:

1. Try printing the file to a pdf printer. See if it still has the same problem.

2. Try saving the as PDF. File-->Save As-->PDF or XPS , see if the problem persists.

From what I can understand now is that there is a problem in the specific printer you are using? Is everything else printing correctly?

Shows up the same way it does in my print preview.

  I8PP said:

Just a guess, but it looks like the printer has been set to print 4 sheets per page.

Now that you say something, it does look like that, but the setting seems all normal. I went into printer properties and checked the settings. Am I missing another one somewhere? (Attached screenshot)

...

Well, since it doesn't appear to be the file, maybe I'll try uninstalling and reinstalling Office and the printer. Any other way to reset printing options to all defaults?

[celestialspring]

With the second image you have posted. Change the setting to "Adjust to 100% of normal size"

Secondly check your paper size.

[family guy]

  celestialspring said:

With the second image you have posted. Change the setting to "Adjust to 100% of normal size"

Secondly check your paper size.

Done and done. Still doesn't fix it. I'll try an uninstall and reinstall tomorrow.