header info in multiple sheets

[fgwiii]

Is there an easy to place several lines of text in the header for multiple
sheets (20 or so) in a workbook? These sheets already exists, in case you
were wondering.

Thank you,

 

[Pete_UK]

Select the first sheet then hold the <shift> key down and select the
last sheet (assuming you want to change all of them - if not, use
<ctrl> when selecting). Now that you have grouped all the sheets, any
changes you do to one will be reflected in all the others (so be
careful !!), so if you click on Page Setup | Header&Footer tab and
then "pretend" to edit the text, that text will then appear in each of
the selected sheets.

Ungroup the sheets when you are finished by right-clicking on a sheet
tab.

Hope this helps.

Pete

 

[Bernard Liengme]

First group the sheet: click on the tab of the first sheet, hold SHIFT,
click on the tab of the last sheet
Note how all tabs have the same 'colour'
Now add the Header :
in Excel 2003 View | Headers | Custom,
in Excel 2007: Page Setup; click the launch arrow on the Sheet
Options group: open Header & Footers tab
Ungroup the sheets by click the tab of any one of the sheets
best wishes

 

[fgwiii]

Thank you!!

First group the sheet: click on the tab of the first sheet, hold SHIFT,
click on the tab of the last sheet
Note how all tabs have the same 'colour'
Now add the Header :
in Excel 2003 View | Headers | Custom,
in Excel 2007: Page Setup; click the launch arrow on the Sheet
Options group: open Header & Footers tab
Ungroup the sheets by click the tab of any one of the sheets
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email