Customizing Worksheet Printing

At some point you'll want to print your worksheet so you can distribute it to others or use it for other purposes. You can print all or part of any worksheet, and you can control the appearance of many features, such as whether gridlines are displayed, whether column letters and row numbers are displayed, or whether to include print titles, columns and rows that are repeated on each page. If you have already set a print area, it will appear in the Print Area box on the Sheet tab of the Page Setup dialog box. You don't need to re-select it.

Print Part of a Worksheet

Click the File menu, and then click Page Setup.

Click the Sheet tab.

Click in the Print Area box, and then type the range you want to print. Or click the Collapse Dialog button, select the cells you want to print, and then click the Expand Dialog button to restore the dialog box.

Click OK.

Print Row and Column Titles on Each Page

Click the File menu, and then click Page Setup.

Click the Sheet tab.

Enter the number of the row or the letter of the column that contains the titles. Or click the Collapse Dialog button, select the row or column with the mouse, and then click the Expand Dialog button to restore the dialog box.

Click OK.

Print Gridlines, Column Letters, and Row Numbers

Click the File menu, and then click Page Setup.

Click the Sheet tab.

Select the Gridlines check box.

Select the Row And Column Headings check box.

Click OK.

Fit Your Worksheet on a Specific Number of Pages

Click the File menu, and then click Page Setup.

Click the Page tab.

Select a scaling option.

• Click the Adjust To option to scale the worksheet using a percentage.

• Click the Fit To option to force a worksheet to be printed on a specific number of pages.

Click OK.