I have a document with multiple worksheets that each contain multiple
pages. I am trying to print a single page (ex. page 8 of 10) from all
of the worksheets with a single print command. As of right now, I
click on each worksheet tab and then tell it to print page 8 of 10,
but that takes too long. Is there a way to condense the information to
print all page 8's at once?

Thank you for any help in advance!

Do the following:

1. In the first sheet in the workbook, select the whole ranage of text in
page 8 and press the CTRL key and select the whole text of page 9.

2. Press the Shift key and click each sheet tab or press the shift key and
click the last tab - all sheet tabs will be selected. Wheich means all sheet
selections are grouped now.

3. On the File menu, click Print.
The Print dialog is displayed.
4. Under Print range, click ALL
5. Under Print What, click Selection.
6. Click OK.
All Eighth page and Tenth page of each sheet will be printed.

Note: I tried this and it works.

Challa Prabhu

" wrote:

I have a document with multiple worksheets that each contain multiple
pages. I am trying to print a single page (ex. page 8 of 10) from all
of the worksheets with a single print command. As of right now, I
click on each worksheet tab and then tell it to print page 8 of 10,
but that takes too long. Is there a way to condense the information to
print all page 8's at once?

Thank you for any help in advance!

Thank you! That solved my problem and will save me hours and hours in
the future. Thank you for your assistance.