Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print preview,scaling, hardcopy don't agree (Excel 2000)

    Actual spreadsheet is 6 columns fits one page. Rows at 100% fits 1.5 pages. Set print area for these columns and rows. When page setup scaling fit to one page is selected, the following happens.
    Print preview and scaling self adjust to 10%.
    Print preview displays 6 pages at 10%.
    Hard copy is at actual size, 1.5 pages.
    No macros in spreadsheet. How do I get this to scale to one page instead of six? Thanks.....

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print preview,scaling, hardcopy don't agree (Excel 2000)

    I guess that you need to attach your workbook. I followed your instructions and got a single page at 67% hard & preview, running XL2K, SR1. Have you tried it with a new workbook? --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print preview,scaling, hardcopy don't agree (Excel 2000)

    We tried a different printer with favorable results then went back to the default printer and got favorable results there too. Go figure!!! Thanks.....

Posting Permissions

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