print title on all pages in Excel

Q126. I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

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 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 excel 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 excel excel excel print title on all pages


You can find similar Excel Questions and Answer hereunder

1) How can I activate a routine when there is a change in value of a cell?

2) How can I delete all shapes in a WorkSheet?

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

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

5) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

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

7) How can I find the count of records that meet a given condition in my raw data table?

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

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

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

11) How can I prevent other users from adding or deleting Sheets in file?

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

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

14) How can I get row count of filtered data?

15) I have a column header Title that is big - I cannot increase the size of column. In Excel, how can I somehow fit the Title retaining the existing column width?