Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Module 5 - Spreadsheets
Lesson 5 - Index Formatting a Page

Section 8 - Headers and Footers

Choose the Header/Footer tab to create a header or footer. The Header/Footer is use d t o place information at the top or bottom of each page. A header is text that appears at the top of each worksheet page. A Footer appears at the bottom of each page.

  • Choose the Header/Footer tab from the Page Setup dialog box. You can use a default header/footer by clicking on the pull down arrow next to either header or footer. You can then select whatever available option best fits your needs.

Excel XP

Page Setup Dialog Box: Header/Footer Tab

Excel 2007

Excel 2007 Header Footer

  • The only difference from Excel XP is that in Excel 2007 you have the option to check the box of having the header or footer different on the odd and even pages or different on the first page, as shown on the previous page.
  • If you want to create a custom Header/Footer, click on the button for creating a Custom Header or Custom Footer in the Page Setup Header/Footer tab.

Custom Header/Footer Buttons

  • A new Header or Footer dialog box will open showing the Header/Footer broken into three sections, left, center, and right. Edit the Header or Footer by typing text or selecting from the buttons for page numbers, date, and time.

Header Window

  • Click on OK to close the Header/Footer dialog box.
Module 5 Lesson 5 Section 7
Module 5 Lesson 5 Section 9

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 08/2007
© 2003, St. Edward's University