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 strongm 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
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
236
combo
combo
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
367
SkipVought
S
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
283
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
283
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
852
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top