It’s easy to add headers and footer to your Excel spreadsheets, similar to those added to Word documents. The Excel headers and footers allow you to include document details, such as titles, dates, page numbers, locations, etc. while also making the spreadsheet more professional looking in appearance. Below are the step-by-step instructions for working with Excel Headers and Footers.
Working with Headers
Creating a Header
- Click the Insert tab.
- Click Header & Footer in the Text group.
- Excel will switch to the Page Layout view.
- Click the left, center or right header text box at the top of the worksheet page.
- Type the header.
- Elements can be added to the header from the Header & Footer Elements group on the Design tab.
- Options can also be set from the Options group on the Design tab.
- Header & Footer Elements allows you to add specific elements to your Header:
- Options allow you to format the header.
- Different First Page – Create a different header for the first page, similar to the Word feature.
- Different Odd & Even Pages – Create different headers for odd and even pages.
- Scale with Document – Scale the Header to match the spreadsheet scaling.
- Align with Page Margins – Align the header margins to match the spreadsheet margins.
- Once you have completed setting up your header, click the Normal View icon to the right side of the status bar to return to the normal view.
Using Built-in Header
- Once you have navigated to the header in the Page Layout view, click the Design tab.
- Click Header in the Header & Footer group.
- Click one of the listed headers.
- Click the Normal View icon to the right side of the status bar to return to the normal view.
Working with Footers
Creating a Footer
- Click the Insert tab.
- Click Header & Footer in the Text group.
- Excel will switch to the Page Layout view.
- Click Go to Footer from the Navigation group on the Design tab.
- Click the left, center or right footer text box at the top of the worksheet page.
- Type the footer.
- Press Enter to start a new line in the footer.
- To include an ampersand (&) in the text of the footer, use two ampersands. Example: Smith & Jones LLC would be typed as Smith && Jones LLC in the footer area.
- Elements can be added to the footer from the Header & Footer Elements group on the Design tab.
- Options can also be set from the Options group on the Design tab.
- Header & Footer Elements allows you to add specific elements to your Footer.
- Options allow you to format the Footer.
- Different First Page – Create a different footer for the first page, similar to the Word feature.
- Different Odd & Even Pages – Create different footers for odd and even pages.
- Scale with Document – Scale the footer to match the spreadsheet scaling.
- Align with Page Margins – Align the footer margins to match the spreadsheet margins.
- Click the Normal View icon to the right side of the status bar to exit the header and return to the normal view.
Using Built-in Footer
- Once you have navigated to the header in the Page Layout view, click the Design tab.
- Click Footer in the Header & Footer group.
- Click one of the listed footers.
- Click the Normal View icon to the right side of the status bar to exit the footer and return to the normal view.
To learn more about Office applications, please check out my courses at vlbteched.teachable.com.
Hey There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and return to read more of your useful info. Thanks for the post. I’ll certainly comeback.
fantastic publish, very informative. I wonder why the other specialists of this sector don’t understand this. You must proceed your writing. I am sure, you’ve a huge readers’ base already!
bookmarked!!, I like your web site!
Pretty! This has been an extremely wonderful article. Many thanks for supplying these details.
I have learn some good stuff here. Certainly worth bookmarking for revisiting. I wonder how much effort you set to create this type of magnificent informative website.
Thank you for sharing your thoughts. I really appreciate your efforts and I am waiting for your further write ups thank you once again.
I bookmared your site a couple of days ago coz your blog impresses me.;;-`;
Precisely what I was looking for, regards for putting up.
I really appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thanks again!