How many rows printed per sheet would probably depend upon the print range set
on each sheet.
Some print setup features can be set with the worksheets "grouped".
Right-click on a sheet tab and "select all sheets"
Then set up the active sheet and all sheets will receive same setup.
EXCEPTIONS..............
Print Range cannot be set on grouped sheets.
Rows to repeat at top cannot be set on grouped sheets.
To set these two items on all sheets would require VBA code.
If interested in some code, post back.
Gord Dibben MS Excel MVP
On Fri, 08 Sep 2006 22:04:07 +1000, Janev <newcole[ at ]comcen.com.au> wrote:
[Quoted Text] >I often have to print a workbook. How does one set up the worksheets
>so that they look consistent. Eg. some worksheets have 10 rows and
>others have 20 so. How does one get the whole set looking coherent?
>
>What formatting tips and tricks are there>
>
>Help appreciated.
>
>Thanks,
>
>Janev
|