How To View Header In Google Sheets

In the realm of documentation and data management, Google Sheets stands out as an incredibly versatile tool, offering a plethora of functionalities that make data handling easier. One important feature that often goes unnoticed is the ability to view and manage headers. This blog post will guide you through the process of viewing headers in Google Sheets.

What is a Header?

A header in Google Sheets is the first row of your spreadsheet where you can name your columns. This makes it easier to understand and manage your data. The header row remains visible even when you scroll down, allowing you to always keep track of what data belongs in which column.

How to View a Header in Google Sheets?

By default, Google Sheets shows the header row at the top of your spreadsheet. However, if you can’t see it, here’s how you can make it visible:

Step 1: Open your Google Sheets document

Firstly, open the Google Sheets document that you want to view the header for.

Step 2: Freeze the rows

Hover your cursor over the thick grey line beneath the row number of your header row. Click and drag down until you’ve covered all the rows you want to include in your header. Then release the mouse button. Your header rows should now stay in place as you scroll down your spreadsheet.

Using Google Apps Script to View Headers

If you’re more technically inclined, you can use Google Apps Script to view your headers. Here’s a simple script to achieve this:

function viewHeader() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getRange(1, 1, 1, sheet.getLastColumn());
  var values = range.getValues();

This script gets the first row of the first sheet of the active spreadsheet, which is usually the header, and logs it.

To run this script, click on the Extensions menu, then Apps Script. Paste the script in the script editor and click on the play button.


Viewing headers in Google Sheets is a relatively easy task, but it’s crucial for managing and understanding your data. Whether you’re choosing to manually freeze rows or use Google Apps Script, you now know how to keep your headers in view!