How to select a Row or Column as the Print Title of a Microsoft Excel Report

Print Titles is a feature in Microsoft Excel that enables its users to print a row or a column heading on each page of a report. This makes your printed copy easier to read and spot vital details mentioned therein. That said, Print Titles is not the same as the header of a report. Although both appear on the same page, the former occupies the body of the main report while latter prints text in the top margin of the report.

For designating a row or a column as the print title for a report, follow the steps outlined in this tutorial.

Designate a Row or Column as Print Title of an Excel Report

Launch the Microsoft Excel worksheet you would like to print. Then, from the Ribbon menu that appears at the top of the Excel Sheet, select ‘Page Layout’ tab.

Next, look for & click on the ‘Print Titles’ option under it. Please note that the Print Titles command will appear dimmed if you are working in cell editing mode, if a chart is selected on the same worksheet, or if you do not have a printer installed.

Row or Column as Print Title of an Excel Report

On the Sheet tab, under Print titles, do one or both of the following:

  • In the Rows to repeat at top box, type the reference of the rows that contain the column labels.
  • In the Columns to repeat at left box, type the reference of the columns that contain the row labels.

For instance, if you would like to print column labels at the top of every printed page, you could enter $1:$1 in the Rows to repeat at top box.

Once you are done with the job of setting up your worksheet to include row and column headings or labels as Print Titles on every page, simply proceed further to print your worksheet. The changes will be visible only in the preview of the sheet and not the original copy.

If you have selected more than one worksheet for Print Titles, the Rows to repeat at top and Columns to repeat at left boxes will not be available in the Page Setup dialog box.

To clear print titles from a report if you no longer need them, open the Sheet tab of the Page Setup dialog box and then delete the row and column ranges from the ‘Rows to Repeat at Top and the Columns to Repeat at Left text’ boxes.

Click OK or press Enter.

Posted by on , in Category Office with Tags

The author Hemant Saxena is a post-graduate in bio-technology and has an immense interest in following Windows, Office and other technology developments. Quiet by nature, he is an avid Lacrosse player. Creating a System Restore Point first before installing a new software, and being careful about any third-party offers while installing freeware is recommended.