Printing from Microsoft Excel!

[Metaphysical]

I have a Excel file that consists of 56 worksheets with 2 pages on each worksheet.
I want to print page 1 of all 56 worksheets.

Is there an easy way to do this or is it a case of printing from each worksheet one at a time?

[cupra]

Not an ideal solution, but how about recording a macro then running it on each worksheet? You could (if you know a little bit of VBA) edit this to automatically switch sheets as well....

[rinkytink]

Open the Excel Spreadsheet/workbook in question. Click on the tab for the first worksheet. Highlight the print area that you want on the first worksheet (i.e. the first page). Hold down the shift key and select the tab for the last worksheet in your workbook this should make all of the tabs go white. Go to file then print. From the 'print what' area select 'selection' and then okay. What you telling the program to do is print only the area you selected but from all worksheets in the workbook.