To set page breaks within the worksheet, select the row you want to appear just below the page break by clicking the row's label. Then choose Insert|Page Break from the menu bar. You may need to click the double down arrow at the bottom of the menu list to view this option.
Select File|Page Setup from the menu bar to format the page, set margins, and add headers and footers.
Format Text: Click this button after highlighting the text to change the font, size, and style.
Page Number: Insert the page number of each page.
Total Number of Pages: Use this feature along with the page number to create strings such as "page 1 of 15".
Date: Add the current date.
Time: Add the current time.
File Name: Add the name of the workbook file.
Tab Name: Add the name of the worksheet's tab.
Sheet: Check Gridlines if you want the gridlines dividing the cells to be printed on the page. If the
worksheet is several pages long and only the first page includes titles for the columns, select Rows to repeat at top to choose a title row that will be printed at the top of each page.
Select File|Print Preview from the menu bar to view how the worksheet will print. Click the Next and Previous buttons at the top of the window to display the pages and click the Zoom button to view the pages closer. Make page layout modifications needed by clicking the Page Setup button. Click Close to return to the worksheet or Print to continue printing.
To print the worksheet, select File|Print from the menu bar.