JustAnswer > Programming
Ask A Question|Register|Login|Help
JustAnswer

Programming
Ask a Programming Question, Get an Answer ASAP!

Have your own Programming question?

7 Programmers are Online Now
characters left:
Not a Programming Question?
Bookmark and Share

Question

How do you add headers and footers to the first sheet of a workbook and have them repeat on all the sheets in the workbook without entering them one by one?

Submitted: 256 days ago.
Category: Programming
Value: $20
Status: AWAITING CUSTOMER ACTION
+
Read More

Optional Information



Already Tried:
No thanks. I figured out the answer to my question myself!

Answer

Hi,

 

The easiest way to do this is to hold your Ctrl key and click on the sheet tabs at the bottom, one by one. This will select the sheets that you want to have common header for. Then from the menu click File > Page Setup > Header/Footer tab, and apply your header. That should do it.

 

(Note: in Excel 2007 the steps to access Page Setup are slightly different, let me know if you need help in this regard).

 

Hope this helps. Let me know if you have any questions.

 

Picture
Expert: John D
Pos. Feedback: 99.7 %
Accepts: 
Answered: 3/12/2009

BS Degree in Engineering

20 years experience in Excel programming and various major applications.

+
Read More

Related Programming Questions

  • I want this formula to sum only positive numbers, how do i
  • I need to design a tic tac toe game using javascript + HTML.
  • how do create a formula to determine vacation days earned ba...
  • What does "no more new fonts maybe applied to this workbook"
  • two spreadsheets, one is a list of 3 digit numbers and thier
  • I need a amoritation program
  • the row numbers are not visiable on sheets emailed to me. ho...
  • i need to be able to send a sequence of packets containing



Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Question List | Become an Expert | Terms of Service | Security & Privacy | About Us
© 2003-2009 JustAnswer Corp.