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.
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.