When you are working with a large dataset containing hundreds of entries, scrolling down means you quickly lose sight of your header row. Suddenly, you cannot remember if column D represents “Revenue” or “Net Profit”. Instead of constantly scrolling back up to check, you should learn how to freeze rows and columns in Google Sheets. This incredibly simple feature locks specific areas of your spreadsheet in place, ensuring your essential reference data always remains visible on the screen.
In this guide, we will show you exactly how to pin your headers and sidebars in Google Sheets, making massive datasets significantly easier to read and analyse.
How to Freeze a Header Row
The most common use case for this feature is locking the very top row (Row 1) so that your column headers stay visible as you scroll down through the data.
- Open your spreadsheet in Google Sheets.
- Click on the View tab located in the top menu bar.
- Hover your mouse over the Freeze option. A sub-menu will appear.
- Select 1 row.
You will now see a slightly thicker grey line appear directly under Row 1. Try scrolling down; your data will move, but the header row will stay firmly pinned to the top of the screen.
How to Freeze Multiple Rows or Columns
Sometimes, your header might span two or three rows, or you might need to lock a specific column on the left side of your screen (like a list of employee names) so it stays visible when you scroll horizontally.
Using the Menu
- For Rows: Go to View > Freeze and select 2 rows, or click on a specific row (e.g., Row 4) and select Up to current row (4).
- For Columns: Go to View > Freeze and select 1 column, 2 columns, or Up to current column depending on your needs.
Using the Drag-and-Drop Method (Faster)
Once you are comfortable with the feature, there is a much faster way to freeze your data without clicking through menus.
- Look at the very top-left corner of your spreadsheet, the empty grey square located above Row 1 and to the left of Column A.
- Notice the thick grey lines forming the inner border of that square.
- To freeze a row, hover your mouse over the thick grey horizontal line. Your cursor will turn into a small hand icon.
- Click and drag the line down below the row you want to freeze.
- To freeze a column, do the exact same thing with the thick grey vertical line, dragging it to the right.
How to Unfreeze Rows and Columns
If you have inherited a spreadsheet from a colleague and find the frozen sections annoying, removing them is incredibly straightforward.
- Navigate back to View > Freeze.
- Select No rows to unfreeze the top sections.
- Select No columns to unfreeze the side sections.
- Alternatively, use the drag-and-drop method to pull the thick grey lines back to their original position in the top-left corner.
Frequently Asked Questions
Can I freeze rows in the middle of a spreadsheet?
No. Google Sheets only allows you to freeze rows starting from the very top and columns starting from the far left. You cannot lock a random row (like Row 50) while allowing Row 1 to scroll away.
Do frozen rows appear when I print the spreadsheet?
Yes. If you freeze a header row and then print your document across multiple pages, Google Sheets will automatically print that header row at the top of every single physical page.
By taking five seconds to lock your essential data in place, you will drastically improve your productivity and prevent frustrating data-entry errors.
