How To Freeze Google Sheets Row

Here it s cell a3.

How to freeze google sheets row. Alternatively click 2 columns or 2 rows to freeze the first two columns or rows. If your data requires more than a single row you can freeze multiple rows in google sheets. 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. Freeze a column in google sheets. Drag and drop the gray bars.

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. Then as seen on the screenshot go to the menu view freeze 2 rows. On your computer open a spreadsheet in google sheets. You can freeze up to ten rows or five columns in any particular sheet in google spreadsheets. Click 1 column or 1 row to freeze the top column a or row 1.

Freezing columns and rows go to the view menu. Also google sheet can show you the number of rows to freeze based on your current position active cell in the sheet. Use apps script to work with frozen rows columns. Select how many rows or columns to freeze. This is useful when comparing specific rows within a sheet.

To begin select a cell in the column or row you re looking to freeze and then click view freeze from the top menu. Select view and then freeze. The above steps would freeze the top most row of the worksheet. If you are on row 6 if you access the view menu freeze you can see the suggestion up to current row 6. Select a row or column you want to freeze or unfreeze.

Hover the cursor over the freeze option. There are two ways to freeze rows and columns in google sheets. Then open the google sheets spreadsheet you want to freeze a row on. Freeze a row in google sheets. The quickest way to freeze cells in google sheets is by using the gray bars.