Microsoft Excel 2007 - Page Properties and Printing

Set Print TitlesThe print titles function allows you to repeat the column and row headings at the beginning of each new page to make reading a multiple page sheet easier to read when printed.  To Print Titles:Click the Page Layout tab on the RibbonClick the Print Titles buttonIn the Print Titles section, click the box to select the rows/columns to be repeatedSelect the row or columnClick the Select Row/Column ButtonClick OKCreate a Header or FooterTo create a header or footer:Click the Header & Footer button on the Insert tabThis will display the Header & Footer Design Tools TabTo switch between the Header and Footer, click the Go to Header or Go to Footer buttonTo insert text, enter the text in the header or footerTo enter preprogrammed data such as page numbers, date, time, file name or sheet name, click the appropriate buttonTo change the location of data, click the desired cellSet Page MarginsTo set the page margins:Click the Margins button on the Page Layout tabSelect one of the give choices, orClick Custom MarginsComplete the boxes to set marginsClick OkChange Page OrientationTo change the page orientation from portrait to landscape:Click the Orientation button on the Page Layout tabChoose Portrait or LandscapeSet Page BreaksYou can manually set up page breaks in a worksheet for ease of reading when the sheet is printed.  To set a page break:Click the Breaks button on the Page Layout tabClick Insert Page BreakPrint a RangeThere may be times when you only want to print a portion of a worksheet.  This is easily done through the Print Range function.  To print a range:Select the area to be printedClick the Print Area button on the Page Layout tabClick Select Print Area