How to print titles in Excel

In today’s tutorial we are going to learn how to repeat the header row in excel using the Print Titles Option while taking the printout of the data. Take a look at this data set shown below. We can see that there is a lot of information in the sheet and when we take the print out of this it goes beyond one page and the header row is currently not being repeated on the second page.

So let’s use the Print Titles option and make the header row appear on both pages by following these steps which are mentioned in the sections below.

Microsoft Excel is a very useful software when it comes to analysing the data and manipulating large data sets. While dealing with very large data sets, when we take the print of the data the print goes beyond one sheet and in such situations we need to repeat the header row on each page to keep track of the data in every column. Otherwise the printed data doesn’t make any sense after the first page. This is where the Print Titles option comes handy.

Step 1 – Locate Page Setup group under Page Layout Tab

– This setting is available in the Page Layout tab and inside the Page Setup group.
– Here find the Print Titles option as shown above

Step 2 – Select the Header Row to repeat on each page

– After clicking on the Print Titles option a new dialog box will appear asking you to choose the header row to repeat. So choose the Rows to repeat at the top in this dialog box as shown below. By default, the first row is automatically chosen as the Header Row which will be printed as Titles on each page.

Step 3 – Check the print preview

– After choosing the header row to repeat in the Print Titles options we are all set to check the print preview again. This time we’ll see that header row is being repeated on both pages.
– To check the print preview, click on File and then on Print. It will open up the print preview and here we can see that now the header row is appearing on both print pages.