Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template
I have saved a new template, it is only one page long. But whenever i use
the template and go to print it out, i get an additional printed page. i have no idea how to fix it!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template
1) Try highlighting your print area then set PRINT RANGE.
2) Go to the page set up and set it to print to 1 page 3) Check margins - if too small it will force "some blank stuff" onto the 2nd page One of these should work for you - also check PRINT PREVIEW to confirm. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template
i want a template tho. i need it to print one page everytime. it doesnt
have two pages until i've filled in all of my information. then for some reason, it just decides there is a second page too. we use this template ALOT. i dont want to have to set the print range each time. i want it to happen automatically. "Danny C" wrote: 1) Try highlighting your print area then set PRINT RANGE. 2) Go to the page set up and set it to print to 1 page 3) Check margins - if too small it will force "some blank stuff" onto the 2nd page One of these should work for you - also check PRINT PREVIEW to confirm. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template
When I've set my templates, I do as I suggested. That means that all the
formatting goes with it. So if you "PRINT RANGE" then PRINT TO 1 PAGE. That information should be saved with the template. What's happening is some information is "spilling over" onto the next page. Even if its blank stuff. If you have already SET MARGINS (large enough - only takes .01 to cause a next page), SET PRINT RANGE, and have PRINT TO 1 PAGE set, I can't see how it is causing the next page - unless its a "printer" problem not a page setup problem. It IS necessary to make an example page to do this however. All data needs to be filled in with the longest available information to make the form "print correctly" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't open template wizard | Excel Discussion (Misc queries) | |||
Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
=IF problem | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Template in Excel | New Users to Excel |