head multi worksheets

  • Thread starter Thread starter Don Lucove
  • Start date Start date
D

Don Lucove

What is the easiest way to put a header in all sheets of
a workbook other than inserting manually in each one? In
a 25 sheet workbook, that would be time consuming,
particularly if changes are made later on.
 
Don
You can select worksheets the same way you select cells. Click on the first sheet tab, hold the shift key, and click on the last sheet tab. Now that all of the sheets are active, whatever you do to one sheet gets done to all of them. Just be careful, you don't want to forget what you might be over-writing on the other sheets

Good Luck
Mark Graesse
(e-mail address removed)

----- Don Lucove wrote: ----

What is the easiest way to put a header in all sheets of
a workbook other than inserting manually in each one? In
a 25 sheet workbook, that would be time consuming,
particularly if changes are made later on
 
Don

Right-click on a sheet tab and "select all sheets".

Enter your header/titles on the active sheet. All sheets will have the
header/titles.

This function is called "grouping".

You can select specific sheets by using the CRTL button and the mouse or by
clicking first sheet and SHIFT + Click on last sheet.

NOTE: When done, BE SURE to "ungroup" the sheets. What you do to one is done
to all.

Gord Dibben XL2002
 
Back
Top