How To Freeze Google Sheets Row

Click the view option in the menu.

How to freeze google sheets row. This is useful when comparing specific rows within a sheet. Then as seen on the screenshot go to the menu view freeze 2 rows. Select a row or column you want to freeze or unfreeze. Select how many rows or columns to freeze. We will notice we essentially arrived at the same result wherein we can scroll across the data without moving the first two rows and the first column.

There are two ways to freeze rows and columns in google sheets. How to freeze cells in google sheets. In the options that appear click on the 1 row. Drag and drop the gray bars. Alternatively click 2 columns or 2 rows to freeze the first two columns or rows.

Click 1 column or 1 row to freeze the top column a or row 1. To begin select a cell in the column or row you re looking to freeze and then click view freeze from the top menu. Freezing rows and or columns is a useful and simple technique to lock rows or columns of your spreadsheet so that they remain in view even. Here it s cell a3. Use an incredible freeze rows shortcut and.

If your data requires more than a single row you can freeze multiple rows in google sheets. Freezing columns and rows go to the view menu. You can freeze up to ten rows or five columns in any particular sheet in google spreadsheets. Below are the steps to freeze rows in google sheets using the view menu options. The quickest way to freeze cells in google sheets is by using the gray bars.

Then we ll freeze the first column by navigating to view freeze 1 column. Freeze a column in google sheets. Drag and drop the gray bars. Freeze a row in google sheets. Unfreeze rows and columns in google sheets.