Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
The print area of my spreadsheet is around 13x20 cells. What do
I need to do to tell Excel to print my sheet on just ONE page and to cover the ENTIRE page??? I tried setting all margins to 0, set landscape orientation, and I set the "scale" width and height to 1 page. Anybody got any advice?? Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
Look up the FitToPagesWide and FitToPagesTall properties in the help
files... they are properties of the PageSetup object. -- Rick (MVP - Excel) "Robert Crandal" wrote in message ... The print area of my spreadsheet is around 13x20 cells. What do I need to do to tell Excel to print my sheet on just ONE page and to cover the ENTIRE page??? I tried setting all margins to 0, set landscape orientation, and I set the "scale" width and height to 1 page. Anybody got any advice?? Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
If the data isn't enough to fill the page, you could experiment with Font size
-- or even the scaling factor. In xl2003 menus: File|Page setup|Page tab|Adjust to and make it bigger than 100% But if your data doesn't match the same layout of the sheet, you'll find that you can fit the width nicely--or the length nicely--but not both at the same time. Robert Crandal wrote: The print area of my spreadsheet is around 13x20 cells. What do I need to do to tell Excel to print my sheet on just ONE page and to cover the ENTIRE page??? I tried setting all margins to 0, set landscape orientation, and I set the "scale" width and height to 1 page. Anybody got any advice?? Thank you! -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
I think the problem is that I can't find a way to totally eliminate
all the margins. I tried setting all margins to ZERO, yet I still cant seem to find a way to print my sheet to cover the entire page. Ugh, there must be a way?? "Dave Peterson" wrote in message ... If the data isn't enough to fill the page, you could experiment with Font size -- or even the scaling factor. In xl2003 menus: File|Page setup|Page tab|Adjust to and make it bigger than 100% But if your data doesn't match the same layout of the sheet, you'll find that you can fit the width nicely--or the length nicely--but not both at the same time. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
I tried pasting the following Visual Basic code into some of my
Excel modules: With Worksheets("Sheet1").PageSetup .Zoom = False .FitToPagesTall = 1 .FitToPagesWide = 1 End With I then tried printing my sheet, but I saw no difference at all. I just to eliminate all margins to zero, and force excel to print my print area on one ENTIRE page. Got any more tips?? "Rick Rothstein" wrote in message ... Look up the FitToPagesWide and FitToPagesTall properties in the help files... they are properties of the PageSetup object. -- Rick (MVP - Excel) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
If I understand correctly from your response to Dave, you are trying to
print your worksheet from edge-to-edge all around on your sheet of paper... I don't think you will be able to do that. With the exception of smaller photos, it is my understanding that printers don't print that way (something to do with holding the paper as it advance through the printer)... it is a limitation of the printer and not something you are doing wrong in Excel. -- Rick (MVP - Excel) "Robert Crandal" wrote in message ... I tried pasting the following Visual Basic code into some of my Excel modules: With Worksheets("Sheet1").PageSetup .Zoom = False .FitToPagesTall = 1 .FitToPagesWide = 1 End With I then tried printing my sheet, but I saw no difference at all. I just to eliminate all margins to zero, and force excel to print my print area on one ENTIRE page. Got any more tips?? "Rick Rothstein" wrote in message ... Look up the FitToPagesWide and FitToPagesTall properties in the help files... they are properties of the PageSetup object. -- Rick (MVP - Excel) |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can "print area" cover entire page???
Not always.
Sometimes, the limiting factor is the width. Sometimes, the limiting factor is the height. Very rarely do these occur at the same time. (Well, in my experience.) Robert Crandal wrote: I think the problem is that I can't find a way to totally eliminate all the margins. I tried setting all margins to ZERO, yet I still cant seem to find a way to print my sheet to cover the entire page. Ugh, there must be a way?? "Dave Peterson" wrote in message ... If the data isn't enough to fill the page, you could experiment with Font size -- or even the scaling factor. In xl2003 menus: File|Page setup|Page tab|Adjust to and make it bigger than 100% But if your data doesn't match the same layout of the sheet, you'll find that you can fit the width nicely--or the length nicely--but not both at the same time. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts on a "Common Print Area" | Excel Discussion (Misc queries) | |||
Set "Print entire Workbook" property from interop code | Excel Programming | |||
Excel: Narrow print area to wrap to 2nd "column" on page | Excel Discussion (Misc queries) | |||
Excel: Narrow print area to wrap to 2nd "column" on page | Excel Discussion (Misc queries) | |||
What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming |