Headers / footers in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there

This drives me mad.... how can I automatically repeat a header or footer
into each worksheet of an Excel workbook? Somebody please help!!

I currently go in and manually change each one, which is a real pain, when I
want exactly the same header/footer in each worksheet.

Any advice gratefully received! Thanks.
 
Hi
select all required sheets (hold down the CTRL key while doing this). After
this apply your header/footer
 
Hi Frank

Thank you so much for the quick reply - you've saved a (usually intelligent)
girl from a lot of frustration!

Many thanks

Mo
 
You must log in or register to reply here.

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

Similar Threads

Copy of Header-Footer in Excel 3
Headers & Footers _auto update info from a cell in the worksheet 4
Header and Footer 5
How do I make a single header/footer common across all worksheets? 1
Headers & Footers in Excel 1
Headers & footers 3
Setting up Default Headers/Footers in Excel 3
Different headers, same footers on multiple worksheets 2

Back
Top