Put Headers & Footers oin each sheet

mypig7

Active Member
Joined
Sep 27, 2004
Messages
285
Is there a way of putting a header or footer on Sheet 1, which will then also appear on Sheet 2 and Sheet 3, without the need to re-type.

I'm in Offcie 2000.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

gaynard_nelson

Active Member
Joined
Dec 4, 2002
Messages
323
mypig7 said:
Is there a way of putting a header or footer on Sheet 1, which will then also appear on Sheet 2 and Sheet 3, without the need to re-type.

I'm in Offcie 2000.

No. But you should be able to copy and paste.

You might also try to print those sheets in group mode, where you select all of the sheets and then print them. I know from experience if you have set the footer to print using this custom footer

Page &[Page] of &[Pages]

it will number the pages for all sheets in group mode consecutively.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,128
Members
412,305
Latest member
Mozz
Top