How to freeze rows and columns

Created by Athan Romblon, Modified on Fri, 2 Feb, 2024 at 5:00 AM by Athan Romblon

Working off the same spreadsheet, we'll freeze the first row in place. That means if we scroll down the spreadsheet, the first row will still be visible, no matter how much data lies below it. This allows you to have a long list and helps to keep tabs on what you're actually looking at.

There are two ways to freeze rows:

  1. Click View > Freeze > 1 row in the navigation bar to lock the first row in place.

  2. Hover over the dark gray bar in the top-left of the spreadsheet (until it becomes a hand), and drag between rows 1 and 2.

Screenshot of spreadsheet with arrow pointing to "1 row" button and another arrow pointing to the gray bar in the top left corner.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article