Print Row and Column Titles on Each Page : Print « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Workbook Worksheet
3. Print

Click the Page Layout tab. 
           Click the Print Titles button.

The Page Setup dialog box displays 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. 
           Then click the Expand Dialog button to restore the dialog box.

Click OK.

7.4.Print
	7.4.1.	Print comments
	7.4.2.	Print Part of a Worksheet
	7.4.3.	Print Row and Column Titles on Each Page
	7.4.4.	Print Gridlines, Column Letters, and Row Numbers
	7.4.5.	Fit a Worksheet on a Specific Number of Pages
	7.4.6.	Set the Print Area
	7.4.7.	Add to a print area
	7.4.8.	Clear the Print Area
	7.4.9.	Preview a Worksheet
	7.4.10.	Preview the worksheet from the Print dialog box
	7.4.11.	Print All or Part of a Worksheet