To set header and footer margins for a worksheet, click on the worksheet.
To set header and footer margins for several worksheets, click the worksheets.
Do as follows
1. Pull down the File menu and click Page Setup.
2. Click the Margins tab.
To change the distance between the top of the page and the header, enter a new margin into the Header: box.
To change the distance between the bottom of the page and the footer, enter a new margin into the Footer box.
3. Click OK.