How to print same heading to all pages?

Asked By 30 points N/A Posted on -

Hi expert,

Can you help me to solve this Excel problem?

In my excel sheet there is a table which includes thousands of data. (See the image).

Page Setup for print

When I am going to print this table headings are displayed only on the first page.

But I want to heading are available in every page print.

How can I get the heading to each page I print?


Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #134001

How to print same heading to all pages?


When printing a table in Microsoft excel you are able to print the title (Headings) in every page that you are going to print. Please follow these steps carefully.

I will take the same table that you have taken in your question.

First click on the page Layout tab. Then click on the print titles in page setup section.

See the below image.

Print page setup

Then click on the sheet tab and click on the red arrow which is in the print area box.

Set printing Area

Select the entire table that you want to print. And click again on the red arrow.

Select the Sheet For Print

Again click on the red arrow in the rows to be repeat box and click on the row which includes headings.

Setting Header for print

Now click again on the red arrow and click ok.

Now go to the print preview and check. Heading will be appearing in ever sheet you print.

Answered By 0 points N/A #134002

How to print same heading to all pages?


Here’s what you can do. Press “File” then “Print” then select “Page Setup” after that press the “Sheet” tab.

Then there’s a selection there were in it says “Print titles” under that is “Rows to repeat at top:” then select the header of the files that you want to print in your case MONTH, CUSTOMER SALES and AMOUNT so you can highlight “A2:C2” as your “Rows to repeat at top:”.

Hope this helps.

Answered By 0 points N/A #134003

How to print same heading to all pages?



In Excel while printing pages there in an option known as HEADER which can solve your problem.

Here is the solution:


In Excel click on “File”

#2 then “Print”


Just simply press “Ctrl+P” to get the Print window open

#3 Click on “Page Setup”

#4 Click on “Header/Footer”

#5 Click on “Custom Header”

Here is the 

Page Setup for print

#6 Now here you can write Heading as in center, left or right side anywhere you want. 

PRint page setup

#7 Here are the Screen shots of the pages & their Headings/Headers.

Proper set page to print

And same Heading on.

set heading for print

Now print & it will show same Heading/Header on All pages.

Hope it will help.

Login/Register to Answer

Related Questions