header info in multiple sheets

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

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,
 
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
 
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
 
Thank you!!

Bernard Liengme said:
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
Click to expand...
 
Back
Top