THANKS to both of you!!! This is the BEST place to find answers to those
pesky little questions that can be so annoying. I tried Sheelo's suggestion
and it did just what I wanted it to do. Then just out of curiosity I tried
Gord's. I got the Select All Sheets---but could not find the "Ungroup
Sheets". I'm not sure I would ever need this, but it's nice to have in the
back of my mind, just in case.
THANKS again to you for answering so quickly!!!

"Gord Dibben" wrote:

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!