Modify header/footer for workBOOK

J

JimO

In Excel 2000, is there an easy way to make/change one
header/footer for all the worksheets? I have a workbook
that contains roughly 20 worksheets, and I don't want to
ahve to go to each worksheet to enter the header/footer.
 
F

Frank Kabel

Hi
just select all worksheets (group them. e.g. holding down the SHIFT key
while selecting them). then change the header/footer
 
J

JimO

Woot! Thanks Frank! That worked just like I had hoped.
-----Original Message-----
Hi >just select all worksheets (group them. e.g. holding
down the SHIFT key >while selecting them). then change the
header/footer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top