1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.PR

  • Excel Printing Issue - print area cut off

    From [email protected]@21:1/5 to All on Wed Nov 8 06:54:59 2017
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Thu Nov 16 20:10:03 2017
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to Ron@Buy on Fri May 18 06:34:53 2018
    On Friday, February 20, 2009 at 2:50:02 AM UTC-5, Ron@Buy wrote:
    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" wrote:

    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

    Thank you!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to [email protected] on Thu Aug 9 07:13:43 2018
    On Thursday, November 16, 2017 at 11:10:04 PM UTC-5, [email protected] 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!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to Ron@Buy on Fri Oct 12 10:35:03 2018
    On Friday, 20 February 2009 00:50:02 UTC-7, Ron@Buy wrote:
    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" wrote:

    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

    legend

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Wed Oct 24 07:00:19 2018
    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 ----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From An Le@21:1/5 to All on Tue Nov 21 09:07:43 2023
    Vào lúc 16:15:01 UTC+7 ngày Thứ Sáu, 20 tháng 2, 2009, Ruby đã viết:
    Thank you very very much. It worked perfectly!
    --
    Ruby
    "Ron@Buy" wrote:
    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" wrote:

    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
    Thanks Ron, up to now, it still works perferctly

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)