Recurring Titles

D

Don

How can I create recurring titles on different worksheets without having to
retype them? Thanks...
 
B

Bernard Liengme

Hi Don:
Click the tab of first sheet; hold SHIFT; click the tab of the last sheet
The sheets are now 'grouped' - note they all have the same tab shading, and
the title bar shows [Group]
Type whatever titles are needed
Ungroup sheets by clicking any sheet tab, or right click a tab and use
Ungroup Sheets
best wishes
 
D

Don

Thank you. That was easy.
--
Don Rountree


Bernard Liengme said:
Hi Don:
Click the tab of first sheet; hold SHIFT; click the tab of the last sheet
The sheets are now 'grouped' - note they all have the same tab shading, and
the title bar shows [Group]
Type whatever titles are needed
Ungroup sheets by clicking any sheet tab, or right click a tab and use
Ungroup Sheets
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Don said:
How can I create recurring titles on different worksheets without having
to
retype them? Thanks...
 
Top