Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set the print range on a form. Regards
I've created a Timesheet on a form in Excel, but when I print, it only prints
a third of the form |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set the print range on a form. Regards
Enter this into Excel help:
Define or clear a print area on a worksheet This should give you a solution "Dave K" wrote: I've created a Timesheet on a form in Excel, but when I print, it only prints a third of the form |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set the print range on a form. Regards
In Excel 200, you would select the are to print, go to "File", "Print area",
"Set print area". To make it easier and quicker to print in future, you can record a macro as you print the print area and attach it to a button. My comments to "Valleyboy" below may be of interest to you too. Cheers "Dave K" wrote: I've created a Timesheet on a form in Excel, but when I print, it only prints a third of the form |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set the print range on a form. Regards
Select a range for example (A1-C4) and click on the page layout tab. With
the range that you want to be turned into a print area, click the print area drop down menu and click set print area. Thats all there is to it. Hope this helped. "Dave K" wrote: I've created a Timesheet on a form in Excel, but when I print, it only prints a third of the form |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to print and email a form | Excel Discussion (Misc queries) | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
Form print | Excel Discussion (Misc queries) | |||
Automatically print the LAN ID into a form | Excel Discussion (Misc queries) | |||
Print a form | Excel Discussion (Misc queries) |