How to Freeze Rows and Columns in Google Sheets

December 21, 2023
David Sunnyside

When working with a large spreadsheet in google sheets, it can be difficult to keep important information on the screen as you scroll up and down. You can solve this problem by using the freeze rows function, which allows you to keep a row or column visible as you scroll.

The process of freezing a row is simple and straightforward, and it works on both the desktop and mobile versions of google sheets. To start, select a cell that is a part of the row up to which you want to freeze. Next, go to the "View" tab in the menu bar, and then choose "Freeze up to row X". A thick light grey border shows up between row X and row X+1.

You can also freeze columns in the same way as you can freeze rows. The main reason why you would want to do this is so that you can easily see the headers of a certain column when scrolling down the spreadsheet. This can be especially useful when managing large datasets, as it will help you to quickly find and compare the data that you need.

To freeze a column, simply click and drag the vertical gray bar that separates the row numbers from the letter for each column. Once you have clicked and dragged this bar, the column will stay in place as you scroll up and down the spreadsheet. The same process can be repeated to freeze multiple columns as needed.

David Sunnyside
Co-founder of Urban Splatter • Digital Marketer • Engineer • Meditator
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram