head multi worksheets

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.
 
M

Mark Graesser

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
[email protected]

----- 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
 
G

Gord Dibben

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
 
Top