How to Create a Custom Header or Footer in Excel 2013
How to Use the Page Break Preview in Excel 2013
How to Solve Page Break Problems in Excel 2013

Excel 2013: Using the Print Titles Feature

Step 1 of 4
Previous
Next Slideshow
Next Slideshow

Click the Print Titles button on the Ribbon’s Page Layout tab or press Alt+PI.

The Page Setup dialog box appears with the Sheet tab selected.

To designate worksheet rows as print titles, go to Step 2. To designate worksheet columns as print titles, go to Step 3.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Cancel Print in Excel 2013
How to Print Only the Charts in Excel 2013
How to Print Worksheets in Excel 2013
Make Your Own Customized Excel 2013 Header or Footer
How to Split the Worksheet into Windows in Excel 2013