SET PRINT MULTIPLE SHEET IN EXCEL

[Tonyb13]

How do i set print multiple sheet to print each on one page

 

[Paul B]

Tony, see if this will do what you want
http://www.mvps.org/dmcritchie/excel/snakecol.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Samir Kapadia]

Hi

Try this:

1) Group the sheets (press shift/ ctrl , click on the sheet tabs)
2) print

Please bear in mind that the formats (rows & col) have got to be similar on
the selected/ grouped sheets, otherwise the result may not be as desired.

regards

Sam