ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I set the print range on a form. (https://www.excelbanter.com/excel-discussion-misc-queries/259040-how-do-i-set-print-range-form.html)

Russell Brogan

How do I set the print range on a form.
 
* 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 : )

grizzly6969

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 : )



All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com