I have a workbook with 20 or so worksheets, each sheet is designed to print
out on an A4 page, once a month i need to print out approx 18 of these
sheets, is there a way to print out all 18 sheets in 1 go rather than going
to each sheet and clicking print ?

Graham

Hold down the Ctrl and click the sheets you want to print (Non contiguous
sheets) or the shift key and click the first and last sheets you want to
print (Contiguous sheets).

[Group] will appear in the application title bar. Anything you then do to
any sheet will happen to all. select Editprint... and ensure active
sheet(s) are selected and press ok

To ungroup, right click any grouped sheet tab

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Graham7979" wrote in message
...
I have a workbook with 20 or so worksheets, each sheet is designed to print
out on an A4 page, once a month i need to print out approx 18 of these
sheets, is there a way to print out all 18 sheets in 1 go rather than
going
to each sheet and clicking print ?