All Pages Don't Print

P

pclark

I have an excel doc that has 4 pages. When I print the
doc, the only page that prints is the page that is
currently open. I have to click each tab at the bottom of
the page to print each page. Is there a way to set the
doc so when I click print, all pages print?
 
A

Andy B

Hi

Group the sheets before you hit print (right click on one of the tabs and
click 'Select all sheets'
Don't forget to ungroup them afterwards, though.

Andy
 
R

Ron de Bruin

Another way is to right click on the file in Windows explorer
And click on Print
 
R

RagDyer

<File> <Print>
Under "PrintWhat"
Check "EntireWorkbook"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top