Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fit to scale (Excel 2k)

    I have a document that I am using as a tally sheet. I have 23 rows and I want them to adjust to their greatest possible height to fit on legal size paper. I've tried the "fit to" and adjusting the scaling %, and increasing the row height globally, but I keep getting the same result. The actual grid is only printing on about 2/3 of the page. It is set to portrait, and my colums are fitting just perfectly.

    Any help?

    Thanks,
    Gabi

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fit to scale (Excel 2k)

    Strange. Adjusting the rowheight should enable you to increase the height of the rows <img src=/S/smile.gif border=0 alt=smile width=15 height=15> and thus make them take more space on the sheet.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Fit to scale (Excel 2k)

    Have you tried deleting the "empty columns to the right and empty rows at bottom, resaving and reopening? Have you tried setting the "print Area"?
    Many times excel will adjust based on things you don't plan on printing and this could screw up the autofit.

    What happens if you don't autofit but just manually increase the print percentage?

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fit to scale (Excel 2k)

    <hr>I've tried the "fit to" and adjusting the scaling %<hr>

    The "fit to" and "adjust scaling" will often conflict. Also, it depends on what your number of columns is. If you have many columns then "fit to" will adjust for the columns, not the rows.

Posting Permissions

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