This is actually pretty cool, I haven't seen it documented.  Select File,
page setup, sheet, and in the 'print area' box, choose range button on the
right side of the box(also called the collapse dialogue button) and hold
down the left mouse button while dragging over page 1, to select it. Release
the mouse button, type a comma in the print area box, and repeat the
procedure with the mouse to drag over page 3. Do the same for page 5. You
should have a print area dialogue box looking like this:

A3:C8,A17:C23,A32:C35

Notice that the ranges are all from the same sheet.  Excel will start
printing each range on a separate page.  This is especially useful if you
save it as a custom view, and then specify this view in the report manager
add-in, if you have it installed.

To do the same thing with multiple sheets (this is covered in Excel help):

Make a group of the sheets that you want to print.  To do this, hold down
the control key while left clicking on each sheet's tab that you want to
include in the group.  When you execute a file menu command, print for
example, all selected sheets will print their respective print areas.  Each
sheet starts printing on a new page.

To unselect a group, click on a sheet not a member of the group.
Tom Turak


-----Original Message-----
From: Elliott Ryder [mailto:[log in to unmask]]
Sent: Monday, October 01, 2001 1:52 PM

        I have a five page document prepared in Excel 2000. I wish to print
only
pages 1, 3 and 5. How can I do this? The  program will not accept "pages
1,3,5" as in Word 2000, and I cannot imagine that I have to print page 1
and then page 3 and then page 5 as separate requests to the program.

                Curious about the people moderating your
                   messages? Visit our staff web site:
                    http://freepctech.com/staff.shtml