how do you put same title on different pages
 

how do you put same title on different pages
 

Depends what you mean by title...

To put the same values in cell(s) in row 1, for example, group the
worksheets (e.g., select the left-most one, then right-click the
right-most one), then make the changes. Right-click a sheet tab and
choose Ungroup Sheets to avoid overwriting anything else.

If you mean the header, group the sheets, change the header, then
ungroup the sheets..

In article ,
Missladybug30 wrote:

how do you put same title on different pages
 

Or perhaps FilePage setupSheet. Rows to repeat at top.


Gord Dibben MS Excel MVP

On Fri, 21 Apr 2006 08:57:54 -0600, JE McGimpsey wrote:

Depends what you mean by title...

To put the same values in cell(s) in row 1, for example, group the
worksheets (e.g., select the left-most one, then right-click the
right-most one), then make the changes. Right-click a sheet tab and
choose Ungroup Sheets to avoid overwriting anything else.

If you mean the header, group the sheets, change the header, then
ungroup the sheets..

In article ,
Missladybug30 wrote: