How to Print Titles in Excel? (Step by Step)

You have more reasons to smile. If you are already smiling, you have solved the problem of repeating rows in all the printing sheets. However, Excel does not stop repeating rows or columns across all the printing sheets. It can also print you Excel row numbers and column headers. Follow the below steps to do this task.

  • First, press “Ctrl + P,” the shortcut key to print in Excel. In print “Settings,” select “Landscape Orientation.” Next, select “Fit All Columns on One Page.” Now, all the columns are fitted on a single sheet. Now, we need to repeat the heading on all the sheets. Go to “Page Layout” and select “Print Titles” in Excel. Now, we need to do some settings under this window. First, the tab selects the print area in excel. So, we need to print from A1 to H701. Under “Print titles” in Excel, we have an option called “Rows to repeat at top.” Here, we must select our headings, i.e., the first row. Click on the “OK.” We have settings to repeat the top row in all the sheets. Now, click on “Print” and see the print preview. The below preview is the first sheet. From a total of 26 sheets, it has been reduced to 15 sheets now. Now, look at the second sheet preview. It also includes headings.This way, we can have a header across all printing pages.Having column headers on all the printing pages is similar to having row headers across pages. We need to select the column to repeat.

So, we need to print from A1 to H701.

Now, look at the second sheet preview. It also includes headings.This way, we can have a header across all printing pages.Having column headers on all the printing pages is similar to having row headers across pages. We need to select the column to repeat.

Step 1: Go to the “Page Layout” tab and “Headings” under “Sheet Options.”

We can only “View” the headings as of now. To print, we need to tick the checkbox of “Print.”

Step 2: Under “Sheet Options,” click the checkbox “Print.”

We can also do this setting under an Excel “Print titles” window. We need to click the checkbox “Row & Column headings.“

Now, press the “Ctrl + P” and select the print preview to see the row numbers and column alphabets.

Things to Remember

This article is a guide to Print Titles in Excel. Here, we discuss examples of repeat Excel header rows, print Excel row numbers and column alphabets, practical examples, and a downloadable template. You may learn more about Excel from the following articles: –

  • Excel Print LabelsExcel Print LabelsIn Excel, the Print label option is printed using the word mail merge function. It saves a lot of time to the users in the arrangement of data as it is presented under the single or multiple labels.read moreInsert Multiple Rows in ExcelQATQATQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read moreSuperscript in ExcelSuperscript In ExcelSuperscripts, like subscripts, are smaller texts and numbers than the rest of the text, but they appear above it.read more