You could select all sheets at once using <cntrl and the mouse pointer
or if that is available in 97 right click on one of the sheet tabs and
select "select all"
You can then hide all the other rows or columns that you do not want to
print and
then print all..
It may pay to do a print preview first.
--
Greetings from New Zealand
Bill K
"Karen" wrote in message
...
I have an employee notebook where each employee has a sheet. The
informtion
for each employee covers four sheets -- one sheet for each calendar
quarter.
I have formulas set up for calculations on all four pages of each sheet.
I
would like to print out just the first quarter for each employee--that
would
be the first page of each sheet. Is there any way to print out the first
page of each sheet in one batch? I am running Excel 1997.
|