If you don’t set it up exactly right, printing an Excel worksheet can be a trip down a rocky road, as well as a waste of paper. To avoid such calamities, you’ll need to preview the page before you print it, make a few adjustments, and then preview it again and again—as many times as you need to until you’re satisfied that the final product will live up to your expectations.
On the Page Layout tab, click the Print Area button, and choose Set Print Area from the drop-down menu.
If your worksheet will occupy more than one page and you want to have the column and/or row headings repeated on each page, click the Print Titles button on the Page Layout tab to display the Sheet tab of the Page Setup dialog box.
Click to minimize the dialog box (yes, this is one of Excel’s eccentricities), select any rows that you want to repeat at the top of each printed page, and press Enter.
Click to minimize the dialog box, select any columns that you want to repeat at the left side of each printed page, and press Enter.
Select the check boxes for the items you want to print and clear the check boxes for the items you don’t want to print.
Switch to Page Layout view, and examine the way the pages will appear.
If you want some of the content to start on a new page, click in the cell where you want the new page to start, click the Breaks button on the Page Layout tab, and choose Insert Page Break from the drop-down menu.
If the page breaks aren’t where you want them, click the Page Break Preview button. Drag a page break to a new position, and adjust other page breaks if necessary.
On the Office menu, point to Print, and click Print Preview in the gallery that appears. Review the pages as they’ll look when printed. Click Close Print Preview, make any modifications to the layout, and recheck the document.
Choose Print from the Office menu, make your printing settings in the Print dialog box, and then print the worksheet or worksheets.