To prevent the footer from overlapping worksheet data, choose Page Setup from the File menu, select the Margins tab, and type a smaller number in the Footer box than that in the Bottom box.
You can hide all the error values in your sheet when you print by going to the sheet TAB in Page Setup and setting Cell Errors to Blank.
Note: You can change the page information (e.g. header, footer, size, type, orientation) by selecting the 'File / Page Setup' menu option, or by pressing the button below.
Your worksheet may be only slightly larger than one page. To print it on one page, click Page Setup on the File menu, click the Page tab, and then specify Fit To 1 Page(s) Wide By 1 Tall.
To add a