Excel 2000 Headers and Footers

R

Reb

Is it possible to copy a custom Header and Footer from one
worksheet to another worksheet in a workbook?
 
F

Frank Kabel

Hi
if your sheet with the header is the first one try the following:
- select this sheet and group the other sheets (e.g. select the other
sheets while holding down the CTRL key)
- now goto 'File - Pagesetup' and click 'OK'

Note: This copies ALL page settings
 
R

Reb

Vielen Dank! Works great!
-----Original Message-----
Hi
if your sheet with the header is the first one try the following:
- select this sheet and group the other sheets (e.g. select the other
sheets while holding down the CTRL key)
- now goto 'File - Pagesetup' and click 'OK'

Note: This copies ALL page settings


--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Top