There scroll down and use the arrows to increase and decrease the number of columns and rows to freeze. A small window will pop up from the bottom part of the screen.On your main spreadsheets page, click on the spreadsheet tab name to open the options that allow you to make tweaks to your spreadsheet.Here are the steps you need to follow to freeze a row or column on google sheets for Android: Hover the cursor over the Freeze option.
#Hot to freeze multiple panes in excel how to
Now you know how to freeze cells in Google Sheets, you can do a similar thing to unfreeze them.Īgain, you can use the mouse to simply drag and bring back the gray lines to the original position, or you can use the Freeze option in the View menu to unfreeze the rows and columns.īelow are the steps to unfreeze rows and columns in Google Sheets: You cannot freeze both rows and columns simultaneously you will first have to freeze the rows and then the columns. Similarly, if you want to lock the first three columns so that these are always visible, select any cell in the third column and choose Up to current column (C) in step 4. The above steps would instantly lock the first five rows so these are always visible when you scroll down. In the options that appear, click on the Up to current row (5).This is because we want to freeze until the fifth row. Similarly, you can use the above steps to freeze two rows or one/two columns.īut what if you want to freeze more than two rows – let’s say you want to freeze five rows?īelow is how to lock cells in Google Sheets when scrolling when you want to lock several: The above steps would freeze the top-most row of the worksheet. In the options that appear, click on the ‘1 row’.Hover the cursor over the Freeze option.Here’s how to freeze the top row in Google Sheets.īelow are the steps to freeze rows in Google Sheets using the View menu options: How to Pin a Row in Google Sheets Using the Menu OptionsĪnother way to quickly freeze rows and columns in Google Spreadsheets is to use the freeze panes Google Sheets option in the menu.Īgain, suppose you have the dataset as shown below and you want to freeze the top row in this dataset. Basically, if you can freeze rows, you already know how to freeze columns in Google Sheets. Drop the line after the column(s) that you want to freeze. With columns, you will have to take the cursor to the vertical gray line and drag it to the right. Similarly, using the mouse is also method of how to make a column stay in Google Sheets. In case you have multiple header rows that you want to freeze, you can simply drag and drop the gray line after these rows. The first row has been frozen and now when you scroll down, you will notice that the header row is always visible (and it only takes a second to do this). That’s it! Now the G oogle Sheets top row is always visible! Since you only want to freeze the top of the row, bring this line just below the first row and leave the mouse key. Hold the left-mouse key and drag this line down.You will notice that the cursor changes to a hand icon. Hover the cursor over the horizontal gray line.There would be a blank gray box with two thick gray lines (as shown below). Take your cursor to the top-left corner part of the worksheet area.Suppose you have the dataset as shown below and you want to freeze the top row in this dataset (as of now, when you scroll down, the headers disappear completely).īelow is how to freeze rows in Google Sheets:: All you have to do is use the mouse, click and drag, and it’s done. I love how easy it is to freeze rows and columns in Google Spreadsheets. How to Freeze a Row in Google Sheets Using the Mouse (Shortcut) So let’s see how to quickly lock some rows and columns in Google Sheets so that these are always visible. Similarly, when you freeze columns, these columns will be visible when you scroll to the right. When you freeze rows in Google Sheets, it will keep these rows visible when you scroll down. How Do I Freeze a Row in Google Sheets Mobile?.Can You Freeze a Single Cell in Google Sheets?.
![hot to freeze multiple panes in excel hot to freeze multiple panes in excel](https://www.keynotesupport.com/excel-basics/img/freeze-multiple-2.png)
![hot to freeze multiple panes in excel hot to freeze multiple panes in excel](https://www.exceltrick.com/wp-content/uploads/2018/10/7.png)
How Do I Freeze the Top Two Rows in Google Sheets?.What Does It Mean to Freeze a Row in Google Sheets?.
![hot to freeze multiple panes in excel hot to freeze multiple panes in excel](https://michelpoudrier.com/images/other/3828/how-freeze-certain-73E778A.jpg)