+ Reply to Thread
Results 1 to 3 of 3

Printing Issue - Fit to Print 1 Page Wide

  1. #1
    Registered User
    Join Date
    03-11-2004
    Location
    Denver, CO
    Posts
    19

    Printing Issue - Fit to Print 1 Page Wide

    I have a spreadsheet that fits fine 1 page wide when I go to page setup and adjust the scalingto 63%. Normally I like to use the "Fit to Print 1 page wide" option but when I select that option the scaling adjusts to 39%.

    I have gone out and deleted all columns to the right and all rows below the area that I want printed to make sure tehre isn't something out there that it is trying to print but it still reduces the size too much.

    I have attached the file that I am tryingto format the printing.

    Thoughts?

    Thanks,

    MD
    Attached Files Attached Files

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    MD,

    I believe the issue has something to do with your defined range names. There are three listed (Insert --> Name --> Define..), and as soon as I remove the "PRINT_TITLE" named range, defined as ='Gantt Chart'!$A:$M,'Gantt Chart'!$1:$6, the print preview fills the entire page.

    Please review that named range, and if not needed remove it. If it's needed, you may need to fix the range it is defining.

    hth

  3. #3
    Registered User
    Join Date
    03-11-2004
    Location
    Denver, CO
    Posts
    19
    You ROCK! Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1