Spreadsheets page setup
To modify margin values Click on the File drop down menu and select the Page Setup command. This will display the Page Setup dialog box. Select the Margins tab and modify your margins as required.
Adjust document setup to fit one page.
To force a worksheet to print on a single page - Click on the File drop down menu and select the Page Setup command. This will display the Page Setup dialog box. Select the Page tab and modify the Fit to section of the dialog box to print on a single page.
Add a Header and Footer.
To create custom headers and footers · From the File menu select Page Setup to display the Page Setup dialog box. Make sure the Header/Footer tab is displayed. Click on the Custom Header or Custom Footer button to display the Header (or Footer) dialog box. In the Left section box, enter any data you want to appear at the left margin of the header or footer. In the Center section box, enter any data you want to appear at the center of the header or footer.· In the Right section box, enter any data you want to appear at the right margin of the header or footer. You can also add the date and time to your header or footer using the Date and Time icons, include file and sheet names in the header or footer using the File and Sheet name icons, and determine which pages the header and footer will appear on using the Page buttons. When you have finished, click on OK to close the dialog box. Your new header (or footer) will be displayed in the Page Setup dialog box in the Header or Footer list box. Choose OK to close the Page Setup dialog box.