How can I force my data to fill the page?

I'm trying to create a staff schedule on one legal-sized page. When I print
it out, I'd like to fill the whole page - automatically resizing whatever
needs to be resized each time. I can't seem to find a way to do this; is
this possible?

The top axis is the date (always seven days), the side axis is staff grouped
by job-type (some staff members appearing in more than one group). This
schedule changes every week, but will always appear on one sheet. At
present, the only way I can fill the page is resizing every single row each
time - pretty painfull, considering the staff size changes with some
frequency.

What am I missing? Can this be automated, or do I have too many variables?

Have you tried 'file'..'page setup' and then click the 'fit to one page'
button?

"edt" wrote:

> I'm trying to create a staff schedule on one legal-sized page. When I print
> it out, I'd like to fill the whole page - automatically resizing whatever
> needs to be resized each time. I can't seem to find a way to do this; is
> this possible?
>
> The top axis is the date (always seven days), the side axis is staff grouped
> by job-type (some staff members appearing in more than one group). This
> schedule changes every week, but will always appear on one sheet. At
> present, the only way I can fill the page is resizing every single row each
> time - pretty painfull, considering the staff size changes with some
> frequency.
>
> What am I missing? Can this be automated, or do I have too many variables?

Thanks, Tim; yes, I have tried that command, but it will only shink the data,
not expand it. It's not the end of the world, of course; sometimes its just
easier to read the schedule if it's bigger - and manually changing everything
is just tedious.

"tim m" wrote:

> Have you tried 'file'..'page setup' and then click the 'fit to one page'
> button?
>
> "edt" wrote:
>
> > I'm trying to create a staff schedule on one legal-sized page. When I print
> > it out, I'd like to fill the whole page - automatically resizing whatever
> > needs to be resized each time. I can't seem to find a way to do this; is
> > this possible?
> >
> > The top axis is the date (always seven days), the side axis is staff grouped
> > by job-type (some staff members appearing in more than one group). This
> > schedule changes every week, but will always appear on one sheet. At
> > present, the only way I can fill the page is resizing every single row each
> > time - pretty painfull, considering the staff size changes with some
> > frequency.
> >
> > What am I missing? Can this be automated, or do I have too many variables?