how to set up same header and footer on each worksheet

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

Guest

i can't find a way to set up a header footer which will stop me having to
type up one on each individual sheet have tried office help and asking
colleagues - help


I want to be able to put my name/date and workheet ref on each individual
worksheet (I know how to do for one sheet but want to apply to all)
Using exel 2003
 
Hi Liana,

select all sheets you want to have the same header or footer (select the
first one and, while keeping Ctrl pressed, click on the tab of each other
sheet, you want to include - you can also use Shift for ranges, as usual...)
go to page setup on the file menu
move to the header/footer tab
enter your header or footer respectively and they will appear on all
selected sheets...

Youppie
 
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

Different headers, same footers on multiple worksheets 2
Inserting the same header/footer on all worksheets in a workbook 7
How do I make a single header/footer common across all worksheets? 1
Headers & Footers in Excel 1
Headers & Footers _auto update info from a cell in the worksheet 4
Header and Footer 5
Headers and Footers size 2
Entering same header & or footer into several worksheets 2

Back
Top