Excel Printing Issue - print area cut off

[Ruby]

Some of my Excel files will not print the entire print area and others will!
It's as if there is a right margin defined which is allowing only about 2-3
inches of the file to print (from left to right). I have Office 2007 and
Vista OS. It doesn't matter if a file is saved as default 2007 version or as
Excel '97 - 2003 version. Nor does it matter if I select "Adjust to" or "Fit
to" in the Scaling section of Page Setup in Print Preview. Also doesn't
matter if I select a specific print area. It's really confusing me - Can
anyone HELP! Thanks
--
Ruby

[Ron@Buy]

After setting Print Area try > View tab > Page Break Preview and adjust the
page size by dragging the blue border lines to suit your size requirements.

[Ruby]

Thank you very very much. It worked perfectly!
--
Ruby

[cap...@gmail.com]

Thanks! This worked for me too

[fce.l...@gmail.com]

thanks worked for me also:)

[atheerba...@gmail.com]

thank you

[ronal...@gmail.com]

TNX.... IT WORKED ...

[bewi...@gmail.com]

Worked great for me thanks for posting

[wayfar...@gmail.com]

Now 8 years later and Ron is still a hero! Worked like a charm, solved a frustrating issue. Thanks Ron!

[tom.r...@gmail.com]

I have been bugged by this for a while now. Worked great.

[ianjohn...@gmail.com]

Almost...

After following Ron's suggestions, I was able to decrease the size of the margin on the right. However, with margins set to 0, I still get a thin strip of white.

A hack was to click page layout, which showed me that the white margin flanked two cells. Adjusting the size of one of these cells such that the split was in between each decreased the right margin further - to a few points. Not perfect, but good enough for now.

If anyone has a better fix, do let me know. Cheers.

http://imgur.com/a/5Ou9r

[andy...@gmail.com]

I had been converting my files from google sheets to excel 2003. I was having the same problem,. It was cutting off about an inch of needed column, until I re-saved my file to make sure it was actually in excel 2003 format.

It worked. I set the percentage size to 95% for the look I wanted on the page. My margins are 1/2" all the way around. I centered the page vertically and horizontally as well.

[andy...@gmail.com]

Well, I learned another thing. My dpi setting was set to 2400 this week. I changed it in Page setup to 600 dpi and it switched imediately to the margin settings I wanted. The whole thing prints correctly now.

[audraje...@gmail.com]

On Friday, February 20, 2009 at 2:50:02 AM UTC-5, Ron@Buy wrote:

Thank you!

[larki...@gmail.com]

On Thursday, November 16, 2017 at 11:10:04 PM UTC-5, andy...@gmail.com wrote:
> Well, I learned another thing. My dpi setting was set to 2400 this week. I changed it in Page setup to 600 dpi and it switched imediately to the margin settings I wanted. The whole thing prints correctly now.

Googled a solution and found this page. thanks!

[danial.d...@gmail.com]

legend

[pbr...@gmail.com]

Wow! Thanks for adding your suggestion. "Print Area" showed full pages, however lines were missing in Print Preview and .PDF creation.
I changed the "dpi" setting to 600 and now all lines print. --- Thanks ----

[An Le]

Vào lúc 16:15:01 UTC+7 ngày Thứ Sáu, 20 tháng 2, 2009, Ruby đã viết:

Thanks Ron, up to now, it still works perferctly