Named ranges prints on separate pages

[Don Rowley]

I have setup a general calendar in excel to track my staff's planned vacation
use. The top of the worksheet has a header with standard information
(company name, dept, etc). There are 12 sections setup for each month of the
year. Each section (month) has dates going across one row and the employees
listed in a column to the left; the time the employee plans to take off is
color coded at the intersection of their name and the date.

I tied the header section with the month section into a named range.
However when I try to print the named range I get a page break resulting in
the header printing on one page and the monthly calendar printing on the
second page. If this is not confusing, is there a way to force this
information to print on one page? I've already changed margins etc. to no
avail.

Thanks

 

[jlclyde]

I have setup a general calendar in excel to track my staff's planned vacation
use.  The top of the worksheet has a header with standard information
(company name, dept, etc).  There are 12 sections setup for each month of the
year.  Each section (month) has dates going across one row and the employees
listed in a column to the left; the time the employee plans to take off is
color coded at the intersection of their name and the date.

I tied the header section with the month section into a named range.  
However when I try to print the named range I get a page break resulting in
the header printing on one page and the monthly calendar printing on the
second page.  If this is not confusing, is there a way to force this
information to print on one page?  I've already changed margins etc. to no
avail.

Thanks

In print preview have you tried pagebreak preview? Then you can move
the blue lines around how you want it to print.
Jay

 

[Don Rowley]

I tried this approach and it didn't work. Thanks for the suggestion though.