Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    best fit page print (XL 2000)

    I wrote a little algorithm to determine the best layout (Portrait/Landscape) to minimize the number of pages while not falling below a specified percentage. This, of course, for large worksheets that won't Fit To One Page. I can't see anything in the Excel 2000 user interface to do this. Have I missed something?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: best fit page print (XL 2000)

    Excel only offers reduction to a fixed percentage, or fit to m x n pages, where the user specifies m and n. There is no optimization option.

Posting Permissions

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