printig rows per page
 

How do I print a given number of rows per page and have the rows height fill
the page, ie. 26 rows top to bottom full page

printig rows per page
 

Hi,

Choose View, Page Break Preview and drag the page breaks (blue line around
to get what you want. Then choose File, Print Preview, click Page Setup and
change the Scaling, Adjust to as needed.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jggsfl" wrote:

How do I print a given number of rows per page and have the rows height fill
the page, ie. 26 rows top to bottom full page

printig rows per page
 

jggsfl wants to expand the 26 rows to fill the space available...

I don't think that is possible without using macros..

Percentage can be more than 100% but to exactly fit desired number of rows
.... not possible, as far as I know.

"Shane Devenshire" wrote:

Hi,

Choose View, Page Break Preview and drag the page breaks (blue line around
to get what you want. Then choose File, Print Preview, click Page Setup and
change the Scaling, Adjust to as needed.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jggsfl" wrote:

How do I print a given number of rows per page and have the rows height fill
the page, ie. 26 rows top to bottom full page

printig rows per page
 

Hi,

Its just the closest the OP is going to get. I don't even think you can do
it with a macro unless you are willing to modify font sizes, column widths
and so on.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sheeloo" wrote:

jggsfl wants to expand the 26 rows to fill the space available...

I don't think that is possible without using macros..

Percentage can be more than 100% but to exactly fit desired number of rows
... not possible, as far as I know.

"Shane Devenshire" wrote:

Hi,

Choose View, Page Break Preview and drag the page breaks (blue line around
to get what you want. Then choose File, Print Preview, click Page Setup and
change the Scaling, Adjust to as needed.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jggsfl" wrote:

How do I print a given number of rows per page and have the rows height fill
the page, ie. 26 rows top to bottom full page