I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the filepage setupsheetsrow thing is not
working!

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

On Fri, 13 Jul 2007 09:22:12 -0700, Starla
wrote:

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the filepage setupsheetsrow thing is not
working!

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?

"Starla" wrote:

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the filepage setupsheetsrow thing is not
working!

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

On Tue, 17 Jul 2007 08:00:00 -0700, Starla
wrote:

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?

"Starla" wrote:

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the filepage setupsheetsrow thing is not
working!

Thank you very much for your help!

"Gord Dibben" wrote:

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

On Tue, 17 Jul 2007 08:00:00 -0700, Starla
wrote:

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?

"Starla" wrote:

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the filepage setupsheetsrow thing is not
working!