How to Pin a Row in Google Sheets

Hi there! Are you tired of constantly scrolling up and down in your Google Sheets to see the column headings or important data? Well, there's a simple solution for that! In this article, I'm going to show you how to pin a row in Google Sheets. Let's get started!

Step 1: Open Your Spreadsheet

First, open the spreadsheet you want to work on in Google Sheets. If you haven’t created a spreadsheet yet, it's pretty easy to start a new one. Just sign in to your Google account and click "New" to create one.

Step 2: Select the Row You Want to Pin

Once you have your spreadsheet open, select the row that you want to pin. This row will stay at the top of your screen even when you scroll down.

Step 3: Click on “View” and then “Freeze”

Next, click on the "View" tab located at the top of your screen and then select "Freeze". A dropdown menu will appear with three options: "1 row", "2 rows" and "up to current row". Since you want to pin only one row, select "1 row" option.

Step 4: Check Your Pinned Row

You will notice that the row you pinned has now turned gray. This indicates that the row is now pinned and will stay at the top of your screen while you're scrolling down through your data. Make sure your pinned row is displaying the data you want to see first on your screen.

Step 5: Unpin Row When Needed

If you ever need to unpin the row, simply click on the "View" tab, select "Freeze" and then click on "No rows" option. This will unfreeze the row and it will go back to its original position on your spreadsheet.


That's it! Pining a row in Google Sheets might seem like a small thing, but it can save you a lot of time and frustration. I hope you found this guide helpful. With this feature, you can now easily navigate your spreadsheet and focus on important data without having to scroll up and down all the time.

Make sure to try it out and let me know how you like it. Also, don't forget to share this article with your friends and colleagues so they can benefit from it as well.

Thanks for reading!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.