View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
grizzly6969 grizzly6969 is offline
external usenet poster
 
Posts: 79
Default How do I set the print range on a form.

in excel 2007 go to Page layout / Print area / Set print area
highlite the area you want to print
--
grizz


"Russell Brogan" wrote:

* The best way to do this is by using your mouse to highlight the range of
cells that

you want to turn into a printed area. For example (A1-C5).

* Then with the range highlighted, click on the "Page Layout" tab on the top
of your

worksheet and find the Print Area button/drop down menu. Click "Set
Print

Area" and you're done.

I hope that I was able to help you out : )