How do I set the print range on a form. Regards

's Computer Specifications

I've created a Timesheet on a form in Excel, but when I print, it only prints
a third of the form

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: How do I set the print range on a form.	grizzly6969	Microsoft Excel Misc	0	16th Mar 2010 09:21 PM
Print All or Page Range doesn't show up in Print menu in Outlook 2	Rich	Microsoft Outlook Discussion	3	5th Jun 2009 07:13 AM
Can you get the range reference for each page in a worksheet print range?	Crosby	Microsoft Excel Programming	3	12th Apr 2005 06:06 PM
Excel 2000 VBA - Set Print Range in dynamic range	sub_pop	Microsoft Excel Programming	2	27th Jul 2004 08:01 PM
My First User Form - How to Select Range(s) and Print	Bruce Roberson	Microsoft Excel Programming	3	25th Jul 2003 03:09 AM