Print Fit To Not Working

J

jutlaux

I am trying to print and excel sheet to one 11X17 sheet. In page setup with
Adjust to set to 100% the preview is 1 page tall by 2 pages wide. When I
select Fit To and set wide = 1 and leave tall {blank} the preview is still 1
page tall by 2 pages wide. I have 5 worksheets in the workbook that are
doing the same thing.

I have tried Clearing the print area, but that doesn't change anything.

I have been able to take all the data and copy it to a new workbook and get
the print setup correct. The problem with this is I have a bunch of links
and calculations that when i do this the don't exist in the new workbook. If
I right click on the tab for the sheet and copy the sheet to a new workbook
this way the links are keep, but then I have the original problem of not
being able to get it to a single 11X17 sheet.
 
J

jutlaux

Figured it out. There was something wrong with the actually printer setup.
Once I changed to another printer everything worked fine. I was even able to
changed back to the original printer and everything was OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top