Print Titles is a function in Microsoft Excel that permits its customers to print a row or a column heading on every web page of a report. This makes your printed copy simpler to learn and spot very important particulars talked about therein. That mentioned, Print Titles aren’t the identical as the header of a report. Though each seem on the identical web page, the previous occupies the physique of the principle report whereas the latter prints textual content within the high margin of the report.
For designating a row or a column as the print title for a report, comply with the steps outlined on this tutorial.
Designate a Row or Column as Print Title of an Excel Report
Launch the Microsoft Excel worksheet you prefer to to print. Then, from the Ribbon menu that seems on the high of the Excel Sheet, select ‘Page Layout’ tab.
Subsequent, search for & click on on the ‘Print Titles’ possibility beneath it. Please observe that the Print Titles command will seem dimmed in case you are working in cell modifying mode, if a chart is chosen on the identical worksheet, or should you do not need a printer put in.
On the Sheet tab, beneath Print titles, do one or each of the next:
- Within the Rows to repeat at high field, kind the reference of the rows that comprise the column labels.
- Within the Columns to repeat at left field, kind the reference of the columns that comprise the row labels.
As an illustration, if you need to print column labels on the high of each printed web page, you would enter $1:$1 within the Rows to repeat at high field.
As soon as you might be carried out with the job of organising your worksheet to embody row and column headings or labels as Print Titles on each web page, merely proceed additional to print your worksheet. The adjustments will probably be seen solely within the preview of the sheet and never the unique copy.
When you’ve got chosen multiple worksheet for Print Titles, the Rows to repeat at high and Columns to repeat at left containers is not going to be obtainable within the Web page Setup dialog field.
To clear print titles from a report should you not want them, open the Sheet tab of the Web page Setup dialog field after which delete the row and column ranges from the ‘Rows to Repeat at Top and the Columns to Repeat at Left text’ containers.
Click on OK or press Enter.
Learn: How to change default quantity of Worksheets in Excel
How do I select rows and columns to Print in Excel?
To select rows and columns to print in Excel, you could select the rows and columns first. Then, you want to go to the Sheet Choices and tick the Print checkbox. Alternatively, you’ll be able to press the common keyboard shortcut to print, Ctrl+P. It can print the chosen rows and columns inside moments.
How do you set row 1 to be a Print title so will probably be printed on the high of each web page?
To set row 1 to be a Print title so will probably be printed on the high of each web page, you want to comply with the aforementioned steps one after one. From right here, you want to select row 1 within the Rows to repeat at high possibility. It’s seen beneath the Print titles part. Following that, your chosen row would be the title on each web page.
That’s all! Hope this information helped.
