Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges prints on separate pages
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prints too many pages | Excel Discussion (Misc queries) | |||
Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
How do I keep heading so it prints on multiple pages | Excel Discussion (Misc queries) | |||
I have too many columns and rows, so it prints too many pages. | New Users to Excel |