Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 97: copy page format (header & footers)?

Status
Not open for further replies.
GinaPhx

GinaPhx

MIS
Jul 21, 2002
14
0
0
US
Excel 97: Is there a way to copy the page format from one worksheet to another (without manually copying each header, footer)?
 
Sort by date Sort by votes
Nevermind, found the answer. Go to Page Setup and click Ok on sheet you wish to copy. Select the other sheets and press F4. They all now have the same header and footer, (but also all the other Page Setup properties, such as print area etc).

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
141
combo
combo
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
216
SkipVought
S
Bijugate
  • Question
Excel update question
Replies
0
Views
99
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top