How to Print Header on Each Page in Google Sheets

Printing Header on each page is important for conveying clear information about the data. Someone may become bamboozled looking at numeric or text entries on page after page of a printed spreadsheet without any header. However, printing the header on each page requires multiple tasks to perform before printing. In this article, we are going to demonstrate a step-by-step solution to print header on each page in Google Sheets.

How to print header on each page in Google Sheets

A Sample of Practice Spreadsheet

You can download the spreadsheets from the link below. The spreadsheets contain a dataset we use here.

Step by Step Procedures to Print Header on Each Page in Google Sheets

Printing header on each page is often necessary for clarification of the data. In this article, we try to provide a stepwise solution to print header on each page in Google Sheets using the following dataset.

Dataset of printing header on each page on Google Sheets

Step 1: Freezing Header Rows

This is the first and foremost step we need to complete for printing header on each page. But, we can easily do that by following the instructions below.

  • First of all, we click on View from the menu bar.
  • Next, we go to Freeze >> 2 Rows.

Freezing first two rows of the current sheet

  • As a result, we got a gray freezing line just below the second row of our dataset.
  • Afterward, we hover the mouse over the freezing line until the cursor changes to a hand icon as indicated in the image below.
  • Then we drag it down to the desired position by holding the left key of the mouse. In this case, we drag down the freezing line up to row 4 to freeze all the headers of the dataset.

Dragging down the freezing line upto desired rows

  • Dragging the freezing line up to row 4 freezes the desired rows of our dataset that contain headers like the image below.

Frozen header rows in Google Sheets

Read More: How to Print Google Sheets on One Page (2 Distinct Scenarios)

Similar Readings

Step 2: Repeating Frozen Rows on Each Page

So far we have done the most important part to print header on each page in Google Sheets. However, this step is also critical and demands careful attention to get the proper output.

  • At the very beginning of this step, we select the Print icon or Ctrl+P for printing.

Printing the current sheet using Print Icon

  • Consequently, the Print settings window opens as follows.
  • Now, we check whether Current sheet is selected or not in the Print box.
  • Afterward, we select A4 as Paper size and Portrait as Page orientation.
  • Then we click on Headers & footers group as indicated.

Changing the Print settings in Google Sheets

  • From Headers & footers, we select Repeat frozen rows as we can see in the image below.

Selecting Repeat frozen rows from Print Settings

  • Now, if we scroll down the printing preview we can see the frozen rows otherwise headers of our dataset on the second page just like the first page.
  • Then we click Next as indicated.

Selecting Next to print header on each page in Google Sheets

Read More: How to Print Preview in Google Sheets (2 Easy Examples)

Step 3: Printing Current Sheet with Header on Each Page

Now, we are on the final line. In this step, we are going to follow the general procedure of printing any document.

  • In this step, we just click on Print as indicated to give the confirmation for printing to our computer.

Selecting Print to print header on each page in Google Sheets

  • As a result, we got the printed document with header on the first page of it as follows.

Header printed on the first page

  • Finally, the second page of our printed document also has the same header as expected.

Same header printed on the second page

Read More: How to Print to PDF Using Apps Script in Google Sheets

Things to Remember

  • Be careful and double-check that you freeze the headers of the dataset only.
  • Make sure the printer is connected to your computer.


In conclusion, I believe from now on you can print header on each page in Google Sheets. Furthermore, If you have any queries regarding this article feel free to comment below and I will try to reach out to you soon. Visit our website OfficeWheel for the most useful articles.

Related Articles



Hey, I'm Zahidul Islam Laku. I completed my graduation from Bangladesh University of Science and Technology (BUET). I write articles about a variety of tech topics. I enjoy using my abilities as a creative thinker and problem-solver to develop original solutions to issues.

We will be happy to hear your thoughts

Leave a reply