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.

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.

"jutlaux" wrote:

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.