How To Freeze Google Sheets Row

To begin select a cell in the column or row you re looking to freeze and then click view freeze from the top menu.

How to freeze google sheets row. Freeze a row in google sheets. Alternatively click 2 columns or 2 rows to freeze the first two columns or rows. Drag and drop the gray bars. The quickest way to freeze cells in google sheets is by using the gray bars. You can freeze up to ten rows or five columns in any particular sheet in google spreadsheets.

To freeze the first two rows we navigate to view freeze 2 rows. How to freeze cells in google sheets. You can open a saved spreadsheet from the home page. Select the row below the one you want to freeze. Then open the google sheets spreadsheet you want to freeze a row on.

At the top click view freeze. 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. 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. Unfreeze rows and columns in google sheets.

Then point your mouse to freeze rows or freeze columns. Hover the cursor over the freeze option. 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 we ll freeze the first column by navigating to view freeze 1 column. This is useful when comparing specific rows within a sheet.

In the options that appear click on the 1 row. Then as seen on the screenshot go to the menu view freeze 2 rows. Use the freeze panes toolbar. Freeze a column in google sheets. Select how many rows or columns to freeze.