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

Home Microsoft Office Excel 2007 Tutorial 1. Introduction 2. Editing 3. Format Style 4. Table 5. Chart 6. Formula 7. Workbook Worksheet 8. Wordart Clip Art Shape Picture 9. PivotTable PivotChart 10. Data Analysis 11. Macro ActiveX Add in 12. Security 13. Collaboration 14. Database functions 15. Date Time functions 16. Engineering functions 17. Information functions 18. Logical functions 19. Lookup Reference functions 20. Math Trigonometry functions 21. Statistical functions 22. Text functions VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Word 2007 Tutorial

Microsoft Office Excel 2007 Tutorial » Workbook Worksheet » Print   7.4.3.Print Row and Column Titles on Each Page 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