How To Freeze Google Sheets Row

The above steps would freeze the top most row of the worksheet.

How to freeze google sheets row. The quickest way to freeze cells in google sheets is by using the gray bars. Below are the steps to freeze rows in google sheets using the view menu options. In the options that appear click on the 1 row. Then point your mouse to freeze rows or freeze columns. Drag and drop the gray bars.

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. Select a row or column you want to freeze or unfreeze. Also google sheet can show you the number of rows to freeze based on your current position active cell in the sheet. Here it s cell a3. At the top click view freeze.

Click 1 column or 1 row to freeze the top column a or row 1. Then we ll freeze the first column by navigating to view freeze 1 column. If your data requires more than a single row you can freeze multiple rows in google sheets. Drag and drop the gray bars. Hover the cursor over the freeze option.

Freeze a row in google sheets. Select the row below the one you want to freeze. Use the freeze panes toolbar. Freeze a column in google sheets. There are two ways to freeze rows and columns in google sheets.

Then as seen on the screenshot go to the menu view freeze 2 rows. To freeze the first two rows we navigate to view freeze 2 rows. Unfreeze rows and columns in google sheets. You can open a saved spreadsheet from the home page. Freezing columns and rows go to the view menu.