| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I repeat rows at the top, except the last page? | Excel Worksheet Functions | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
| copy rows to new page | Excel Worksheet Functions | |||
| ROWS TO REPEAT ON EACH PAGE | Excel Worksheet Functions | |||
| Conditional page break if merged rows won't fit on the page. | Excel Worksheet Functions | |||
Hybrid Mode
