How do I edit or create Headers or Footers in Excel 2007? There are two ways to enter or edit your headers and footers in Excel: one is the classical way as you may have seen in previous version of Excel (and is limited), and the new and improved option Excel 2007 provides. The newer way is a bit trickier and can be executed or found on the Insert Tab, to Text group and clicking on the Header & Footer Button. The reason why is because this will dump you into the Page Layout view, where the only way to get out of this view (when your finished with entering in your headers and footers) is to change your views to Normal - found on you View Tab. See it in action...

Purchase the training video and you can see this in action for yourself!