If printing see Sheelo's reply.

If just want same titles on all sheets...............

Select first sheet and right-click on sheet tab and "Select all sheets"

Enter your row of titles on active sheet and will be done to all.

When done, right-click and "ungroup sheets"


Gord Dibben MS Excel MVP

On Thu, 6 Nov 2008 10:25:03 -0800, Bons
wrote:

Hi Everybody! Have a prob I thought I'd see posted here, but can't find it.
Am doing a spreadsheet for a friend---Has header rows and I'd like them to
show on all pages so I don't have to copy/paste. I was able to do that quite
easily, but feel like there is probably a setting I could hit to tell it to
do it automatically. This is not a monumental deal....just curious. Thanks!