Excel: Printing With Headings and Titles

Titles in Excel are especially handy when you are working on a very long list. Sometimes, we have a hard time printing on this program. We often bump into the problem of missing headings or titles on the other pages. Though the first page looks good, the next ones often are not. This is where the “Print Titles” option become very handy.

Print titles feature makes this problem be solved in a matter of seconds!

So, do you know where to find the “Print Titles” option in Excel? It is found in the Page Layout Ribbon, specifically on the Page Setup group. Just click it and you’ll be happy and surprised with its powerful ability to control on the things you wanted to see on your printed file.

How to Use the Print Titles

The picture below summarizes the steps on using the “Print Titles” option in Excel. You can also refer on the listed steps below to guide you on using this feature.

1. On the Page Layout Ribbon, go to Page Setup and click Print Titles.
2. A dialog box will appear. Click on the Rows to repeat on top – this will be the rows that will be visible on all pages when you print.
3. Select or drag the cells you want to repeat.
4. Click OK and see the result – below is an image (Print Preview) showing the second page of the file. (As you can see, all the titles above – Column Headers – are still included in the output file.)

Note: You can always check on your output file in the Print Preview option.

Print Columns to Repeat with Titles

Just like printing the header row, printing the first column on every page is also possible in Excel. This is also done with the help of the Print Titles option. Instead of choosing the “Rows to repeat on top”, you are going to choose the “Column to repeat at left”, as shown below.

1. On the Page Layout Ribbon, go to Page Setup and click Print Titles.
2. A dialog box will appear. Click on the Columns to repeat at left – this will be the column that will be visible on all pages when you print.
3. Select or drag the cells you want to repeat.
4. Click OK and see the result. The column you selected will be printed on every page of your file.

Titles either on top or on the side of your file are of big help in reading and dealing with it. Knowing this stuffs in Excel is really of big help, especially to those people who are working on very long list and needs a printed output for their work.

Here is another article that might be interesting for you:
Basic Calculations in Excel Your Boss Expects You to Know