Print Titles is a characteristic inwards Microsoft Excel that enables its users to impress a row or a column heading on each page of a report. This makes your printed re-create easier to read too location vital details mentioned therein. That said, Print Titles is non the same every bit the header of a report. Although both look on the same page, the erstwhile occupies the trunk of the chief study spell latter prints text inwards the overstep margin of the report.
For designating a row or a column every bit the impress championship for a report, follow the steps outlined inwards this tutorial.
Designate a Row or Column every bit Print Title of an Excel Report
Launch the Microsoft Excel worksheet you lot would similar to print. Then, from the Ribbon bill of fare that appears at the overstep of the Excel Sheet, pick out ‘Page Layout’ tab.
Next, await for & click on the ‘Print Titles’ selection nether it. Please depository fiscal establishment complaint that the Print Titles ascendency volition look dimmed if you lot are working inwards jail mobile telephone editing mode, if a nautical chart is selected on the same worksheet, or if you lot practise non bring a printer installed.
On the Sheet tab, nether Print titles, practise i or both of the following:
- In the Rows to repeat at overstep box, type the reference of the rows that incorporate the column labels.
- In the Columns to repeat at left box, type the reference of the columns that incorporate the row labels.
For instance, if you lot would similar to impress column labels at the overstep of every printed page, you lot could come inwards $1:$1 inwards the Rows to repeat at overstep box.
Once you lot are done amongst the project of setting upwards your worksheet to include row too column headings or labels every bit Print Titles on every page, only croak along farther to impress your worksheet. The changes volition hold upwards visible exclusively inwards the preview of the canvass too non the master copy copy.
If you lot bring selected to a greater extent than than i worksheet for Print Titles, the Rows to repeat at top too Columns to repeat at left boxes volition non hold upwards available inwards the Page Setup dialog box.
To clear impress titles from a study if you lot no longer demand them, opened upwards the Sheet tab of the Page Setup dialog box too and then delete the row too column ranges from the ‘Rows to Repeat at Top too the Columns to Repeat at Left text' boxes.
Click OK or press Enter.
Source: https://www.thewindowsclub.com/
comment 0 Comments
more_vert