Print title on all pages in Excel

For example, I have a large Table that summarizes the Population and Annual Growth Rates of all countries of the world from 1969 to 2014 (section of the table is below). When printed I want the countries name to appear in every Sheet

on the left as also year at the top of every Sheet.

excel print title on all pages

To do it in Excel, here is the answer:

a) Click on "Print Titles" under "Page Layout".

excel print title on all pages

b) Specify the rows and columns to repeat on each printed page by updating the range against "Rows to repeat at top:" and "Columns to repeat at left:" fields in the "Page Setup" Dialog box that comes up.

excel print title on all pages

c) To update "Rows to repeat at top:" and "Columns to repeat at left:" fields, click on the Range selection icon to the right of the field and select the Row(s) / Column(s) to be repeated (sample row selection shown below). Click OK.

When Printed, the selected Row(s) / Column(s) would be repeated in each printed Sheet.

excel print title on all pages


You can find similar Excel Questions and Answer hereunder

1) How can I edit names of all the Shapes in the WorkSheet easily instead of navigating to each Shape and renaming them?

2) How can I clear all formats (formats alone not data) from a range of cells?

3) How can I list all files in a folder using VBA?

4) Here the different chart types in Excel.

5) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

6) I have entered lot of comments in my WorkSheet - how do I have them show up when printed?

7) How can I loop through all ActiveX checkboxes in WorkSheet and set them to Unchecked status?

8) How to center excel sheet horizontally and verticaly on page in Excel

9) How can I set non-contiguous print area using VBA?

10) How can I add and link a Chart Title to a cell value?


Here the previous and next chapter