Adding A Header Row Using Google Sheets

Creating spreadsheets can be relatively easy to do, but improving your spreadsheet into something more comprehensible for the viewers, well, that’s a different story. Thanks to Google Sheets, you can easily improve the presentation of your spreadsheet with just a few clicks away. You can either insert borders, change the font, or even insert graphs. 


Google Sheets

However, one basic element that a spreadsheet shouldn’t lose is its headers. This is because header rows are very helpful for your spreadsheet, as they show the viewers what every column of your spreadsheet is about. They somehow give a glimpse of what your entire spreadsheet will tackle. 

Nonetheless, header rows can tend to become useless, especially if you have more than a hundred pieces of data in your spreadsheet. You can’t just go to the 100th row of your spreadsheet and scroll back to the header row just to see what it’s about. 

With that, the steps below will not just show you how to add a header row but also freeze them so you can view them no matter how low you scroll down through your spreadsheet.

1. Use your web browser to go to the Google Sheets website.

Open your web browser and use it to navigate your way to the Google Sheets website. Make sure to sign in to your account before formally proceeding to the subsequent steps, as this is important for you to open your previously created spreadsheets.

2. Click on the spreadsheet that you want to edit.

After signing into your account, go through the list of your previously created spreadsheets and select the one that you want to insert a header row in. Click on your chosen spreadsheet to open it. 

3. Insert another row on the top of your data.

One common mistake that people make is to directly type in their sets of data to their spreadsheets, without allocating some space for the headers themselves. This is why as you can see in the picture below, there’s no space left on the top for the headers. To solve this problem, insert a new row by right-clicking on the first row until a dropdown list appears. Then, from the list, click on “Insert 1 row above.” This will add another blank row at the top of your data.

Note: If you still have a space for your headers, you can just skip this step and proceed to the next one.

4. Type in the headers that you prefer to use in each of the cells.

This part will entirely depend on the headers that you’ll use for your spreadsheet. In this case, the headers that will be used are “Student name,” “Q1,” “Q2,” “Q3,” and “AVG Score.” Remember to place the headers at the top of the set of data that correspond to them. 

5. Click on “View” from the menu bar.

After typing in the headers that you wish to use, it’s now time to freeze your header row, so that it’ll appear no matter how low you scroll down through your sheet. To begin, click on the “View” tab from the menu bar located at the top of your screen. Doing this will make a list appear. 

6. Hover your cursor to the “Freeze” option.

From the dropdown list, locate the “Freeze” option and hover your cursor on it to make another list appear. 

7. Click on “1 row” from the list.

The second list that will appear contains another set of options with regards to freezing panes in your spreadsheet. Click on the “1-row” option from the list to freeze the first row of your spreadsheet. Doing this will automatically apply the changes you’ve made, so there’s no need to click on anything else to save it. 

Finishing Thoughts

After properly following the preceding steps, you’ll now notice that your header row has already been frozen. Therefore, no matter how low you go, the headers will be visible on your part. This will help you and those who will view your spreadsheet understand the data that you’ve inputted more effectively.