Automatic Headers and Footers

Question

I am trying to put the same header on every page, and every sheet, of my workbook.  (called automatic headers and/or footers).  I have Microsoft Office Professional Plus 2007.  I am trying to do just a simple Excel chart, nothing complicated, no advanced formulas or macros.

There is a question listed for this, but when I click on the link, it goes to nowhere.

My current instruction book says:

     1.  Display the design contextual tab on the ribbon to add an Auto Header and/or Footer.  (I clicked on the Insert tab, and then clicked on Header....to get to the Design contextual tab)

     2.  Then go to Auto Header and Footer Group, and click Auto Header. 

I could not find anything ANYWHERE that says Auto Header and Footer Group, or Auto Header and Footer.  I assume that finding the Auto Header and Footer Group is the next step - just don't know where that is.  I need VERY consise instructions here - with nothing left out.  You know.  Headers and Footers for dummies?   :-)

Thanks much.

Marianne3

Answer 1

Hi Marianne,

Step 1 is ok.

Step 2 - You should see the Header and Footer Tools Ribbon, click any of the buttons there to add something to the header. Try clicking the Current Time button, it will insert &[Time] in the header.

Then select a worksheet cell. You will see the current time in the header. Keep watching, it will update automatically.

By the way, you are now in Page Layout view, to switch back to Normal view use the View Ribbon. You can't see the header in Normal view, but it is still there when you print the document.

---

Ed Ferrero www.edferrero.com