Repeat title to top of each worksheet

S

Starla

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the file>page setup>sheets>row thing is not
working!
 
G

Gord Dibben

The rows to repeat at top in print setup is only for printing.

Try this if you can't copy.

Select first sheet then right-click and "select all sheets"

Type your title across the top row of active sheet.

Will be done to all.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben MS Excel MVP
 
S

Starla

Thank you for your help, however, I can not use this method. The person I am
figuring this out for remembers selecting what she wanted copied, using a
toolbar and it changing on all sheets. Do you have any suggestions?
 
G

Gord Dibben

Either the person mis-remembers or she had a toolbar with a macro attached to a
button.

Why can't you use the grouped sheets method for entering text in row 1 of each
sheet?

By the way, I forgot to mention that "rows to repeat at top" for printing cannot
be done on grouped sheets.


Gord
 
S

Starla

Thank you very much for your help!

Gord Dibben said:
Either the person mis-remembers or she had a toolbar with a macro attached to a
button.

Why can't you use the grouped sheets method for entering text in row 1 of each
sheet?

By the way, I forgot to mention that "rows to repeat at top" for printing cannot
be done on grouped sheets.


Gord
Click to expand...
 
Top