How To Freeze Google Sheets Row

Select view and then freeze.

How to freeze google sheets row. 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. If you are on row 6 if you access the view menu freeze you can see the suggestion up to current row 6. The above steps would freeze the top most row of the worksheet. Then as seen on the screenshot go to the menu view freeze 2 rows. In the options that appear click on the 1 row.

Select how many rows or columns to freeze. Here it s cell a3. Unfreeze rows and columns in google sheets. Click the view option in the menu. To begin select a cell in the column or row you re looking to freeze and then click view freeze from the top menu.

Use the freeze panes toolbar. To freeze the first two rows we navigate to view freeze 2 rows. Alternatively click 2 columns or 2 rows to freeze the first two columns or rows. Then we ll freeze the first column by navigating to view freeze 1 column. Use an incredible freeze rows shortcut and.

Below are the steps to freeze rows in google sheets using the view menu options. Also google sheet can show you the number of rows to freeze based on your current position active cell in the sheet. If your data requires more than a single row you can freeze multiple rows in google sheets. Click 1 column or 1 row to freeze the top column a or row 1. 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. Select the row below the one you want to freeze. Drag and drop the gray bars. This is useful when comparing specific rows within a sheet. You can open a saved spreadsheet from the home page.