Wednesday, September 19, 2012

How to Change the Footer in Excel 2007


1. Open the Excel document containing the footer that you would like to change. On the tab bar at the top of the page, locate and click the 'Insert' tab.
2. Click on the 'Header and Footer' button located in the text group on the right-hand side. Clicking this button displays the design tab. The header and footer tools located within this tab will allow you to create a new header or footer as well as edit the current header or footer.
3. Click the 'Go to Footer' button within the navigation group. Insert text by simply typing the text you want to appear as your footer within the footer text box. If you are changing an existing footer, delete the text or graphic that is already there, and replace it with whatever text or graphic you want to appear.
4. Select the desired cell where you want the footer to appear or where the current footer exists. Click and type text or choose pre-formatted data.
5. Click on the appropriate button within the header and footer elements group, such as page number, current date or file name, to use any of the pre-formatted data.
6. Navigate back to the body of your document and continue by clicking the 'Home' tab.

Blogger news