Microsoft Excel 2010 provides option for inserting header and footer for Worksheets. This can be done using the Page Layout option.
Click on the View menu and then select Page Layout option.
The following Page Layout view will be displayed.
click the Click to add header text and enter the Header for the Worksheet like Personal Finance
Now scroll to the bottom of the page and using the Click to add footer text you can enter footer for an Excel Page.