Excel Made Easy

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.

To do it in Excel, here is the answer:

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

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.

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.

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?