View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Recurring Titles

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" wrote in message
...
How can I create recurring titles on different worksheets without having
to
retype them? Thanks...
--
Don Rountree