I don't think you can. You'll have to go through each sheet.

jamex wrote:

How to print heading on everypage for all sheets of a workbook.
I grouped all sheets, then went as File-pagesetup-sheet tab, but i
see print titles option is disabled, why. But for single sheet it is
working. Please suggest how to enable it for *all sheets*.
THANKS

--
jamex
------------------------------------------------------------------------
jamex's Profile: http://www.excelforum.com/member.php...o&userid=32243
View this thread: http://www.excelforum.com/showthread...hreadid=520432

--

Dave Peterson