Thursday, November 22, 2012

How to Add a Footer in Excel 2007


1. Click the 'Insert' tab in Microsoft Excel.
2. Click 'Header Footer' in the 'Text' group.
3. Click the bottom scroll arrow until 'Click to add footer' is visible and click it.
4. Type the text you wish to display. To enter dynamic elements, click the appropriate button in the 'Header Footer Elements' group of the current Design tab. Available elements include 'Page Number,' 'Number of Pages,' 'Current Data,' 'Current Time,' 'File Path,' 'File Name,' 'Sheet Name' and 'Picture,' which allows you to add a picture to the footer.
5. Click the 'Home' tab to access text formatting features of the 'Font' and 'Alignment' groups, such as font type, font size, bold, underline, colors and centering.
6. Click the main spreadsheet window to exit the footer.
7. Click the 'View' tab and click 'Normal' to return to the normal view mode.

Blogger news