On the web there are three ways to do it: drag the gray bar, use the View menu, or right-click a row number or column letter. If you know Excel, freeze panes is the same feature. Excel puts it under View > Freeze Panes, and Google Sheets under View > Freeze.<\/p>\n
For the Excel steps, including how to keep the top row and first column in view at the same time, see how to freeze rows and columns in Excel<\/a>.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The freeze feature in Google Sheets<\/a> allows you to pin certain rows or columns within your spreadsheet so that you can continue to view them as you scroll through your data. This is particularly helpful when you have a huge amount of data that you need to evaluate or manage.<\/p>\n Here are just a few situations where you\u2019d want to freeze rows or columns within your data:[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In most cases, you will probably only want to freeze the first row or column of your spreadsheet. However, the freeze feature does allow you to freeze multiple rows or columns; as long as they are next to the first.<\/p>\n Please note:<\/b><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-freeze-a-row-or-column-drag-and-d” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The quickest way to freeze rows and columns in Google Sheets is the drag-and-drop method.<\/p>\n 1.<\/strong> Hover over the empty square where the row headers and column headers intersect. To freeze a row, hover over the bottom line of the square until it is highlighted. Click and drag down to beyond the row you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-rows-google-sheets-drag-bar-corner.webp” alt=”How to freeze rows in Google Sheets \u2014 red arrow on the gray bar in the top-left corner of the sheet” title_text=”Red arrow on the gray bar in the top-left corner of the sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Grab the outline and drag it just beyond the row or column you want.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-rows-google-sheets-drag-below-row-1.webp” alt=”How to freeze rows in Google Sheets \u2014 gray bar dragged down to just below row 1″ title_text=”Gray bar dragged down to just below row 1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> No matter how far down you scroll, the first row will stay in view.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-rows-google-sheets-first-row-frozen.webp” alt=”How to freeze rows in Google Sheets \u2014 header row still on top after scrolling down to row 13″ title_text=”Header row still on top after scrolling down to row 13″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> To freeze the first column, repeat step one, but grab the left-hand line of the corner cell rather than the bottom one. Drag it right to just beyond the column you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-columns-google-sheets-drag-bar-corner.webp” alt=”How to freeze columns in Google Sheets \u2014 red arrow pointing right from the top-left corner” title_text=”Red arrow pointing right from the top-left corner” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Now, no matter how far down or right you scroll, the first row and the first column are always visible.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-rows-columns-google-sheets-both-frozen.webp” alt=”Freeze rows and columns in Google Sheets \u2014 id column and header row in view after scrolling right and down” title_text=”Id column and header row in view after scrolling right and down” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-freeze-the-top-row-or-first-colum” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the steps below to freeze rows or columns from the \u2018View\u2019 menu.<\/p>\n 1.<\/strong> Go to View > Freeze and choose the option you prefer.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-top-row-google-sheets-view-freeze-menu.webp” alt=”How to freeze the top row in Google Sheets \u2014 Freeze submenu open under the View menu” title_text=”Freeze submenu open under the View menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Choose \u20181 row\u2019 to freeze the top row or \u20182 rows\u2019 to freeze the top two. The same options are available for freezing the first or first two columns.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-top-row-google-sheets-1-row-2-rows.webp” alt=”How to freeze the top row in Google Sheets \u2014 1 row, 2 rows, 1 column and 2 columns options highlighted” title_text=”1 row, 2 rows, 1 column and 2 columns options highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-freeze-a-row-or-column-in-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the steps below to freeze a row or column using the right-click menu.<\/p>\n 1.<\/strong> Select the row you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-row-google-sheets-select-row-1.webp” alt=”Freeze a row in Google Sheets \u2014 row 1 selected by clicking its row number” title_text=”Row 1 selected by clicking its row number” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Right-click on the row number to see the menu options. On the menu, go to View more row actions > Freeze up to row 1.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-row-google-sheets-right-click-row-1.webp” alt=”Freeze a row in Google Sheets \u2014 Freeze up to row 1 under View more row actions in the right-click menu” title_text=”Freeze up to row 1 under View more row actions in the right-click menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> To freeze a column, select it and right-click on the column letter to see the menu. Go to View more column actions > Freeze up to column A.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-column-google-sheets-right-click-column-a.webp” alt=”Freeze a column in Google Sheets \u2014 Freeze up to column A under View more column actions” title_text=”Freeze up to column A under View more column actions” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-freeze-multiple-rows-or-columns” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To freeze the first 2 rows or columns of your data, go to View > Freeze and choose 2 rows or 2 columns. To freeze more than two, use any of the three methods shown above: the drag-and-drop shortcut, the View menu, or the right-click menu. Frozen rows always start at row 1, and frozen columns at column A.<\/p>\n Follow the steps below to freeze multiple rows or columns using the drag-and-drop method.<\/p>\n 1.<\/strong> Hover over the empty square where the row headers and column headers intersect. To freeze a row, hover over the bottom line of the square until it is highlighted.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-rows-google-sheets-drag-bar.webp” alt=”How to freeze multiple rows in Google Sheets \u2014 red arrow on the gray bar in the top-left corner” title_text=”Red arrow on the gray bar in the top-left corner” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Click and drag down to beyond the row you want to freeze. In this case, I want to freeze the first four rows.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-rows-google-sheets-drag-past-row-4.webp” alt=”How to freeze multiple rows in Google Sheets \u2014 gray bar dragged down to just below row 4″ title_text=”Gray bar dragged down to just below row 4″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> To freeze the first three columns, repeat step one but grab the left-hand line of the corner cell rather than the bottom one. Drag it right to just beyond the column you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-columns-google-sheets-drag-column-c.webp” alt=”How to freeze multiple columns in Google Sheets \u2014 gray bar dragged right to just past column C” title_text=”Gray bar dragged right to just past column C” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the steps below to freeze multiple rows or columns via the \u2018View\u2019 menu.<\/p>\n 1.<\/strong> Select a cell in the row up to which you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-rows-google-sheets-select-cell-c3.webp” alt=”How to freeze multiple rows in Google Sheets \u2014 cell C3 selected in row 3″ title_text=”Cell C3 selected in row 3″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to View > Freeze and choose Up to row X, where X is the number of the row you selected. The option shows that number, so you can check it before you click.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-rows-google-sheets-up-to-row-3.webp” alt=”How to freeze multiple rows in Google Sheets \u2014 Up to row 3 in the Freeze submenu of the View menu” title_text=”Up to row 3 in the Freeze submenu of the View menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> To freeze a column, select the column up to which you want to freeze and repeat step 2.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-columns-google-sheets-up-to-column-c.webp” alt=”How to freeze multiple columns in Google Sheets \u2014 Up to column C in the Freeze submenu of the View menu” title_text=”Up to column C in the Freeze submenu of the View menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the steps below to freeze multiple rows or columns using the right-click menu.<\/p>\n 1.<\/strong> Select the row or column up to which you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-rows-google-sheets-select-row-3.webp” alt=”How to freeze multiple rows in Google Sheets \u2014 row 3 selected by clicking its row number” title_text=”Row 3 selected by clicking its row number” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Right-click on the row number or column letter to get the menu. Go to View more row actions > Freeze up to row X. In this case, I will freeze up to row 3.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-rows-google-sheets-right-click-row-3.webp” alt=”How to freeze multiple rows in Google Sheets \u2014 Freeze up to row 3 in the right-click menu” title_text=”Freeze up to row 3 in the right-click menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> You can follow the same steps to freeze multiple columns by right-clicking on the column up to which you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-multiple-columns-google-sheets-right-click-c.webp” alt=”How to freeze multiple columns in Google Sheets \u2014 Freeze up to column C in the right-click menu” title_text=”Freeze up to column C in the right-click menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Rows and columns freeze separately, so you can keep a header row and one or more label columns on screen together.<\/p>\n Let\u2019s say I am comparing the number of visitors my company website has had from the beginning to the end of the year.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-15.png” alt=”Freeze rows and columns in Google Sheets \u2014 web page visitors by month, with a Page column and one column per month” title_text=”Web page visitors by month, with a Page column and one column per month” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n I want to freeze the first row of my spreadsheet so that I can easily identify what each column of data refers to. I also want to freeze the ‘January visitors’ column of my spreadsheet so that I can compare the data to the ‘December visitors’ column.<\/p>\n To do that, freeze the first row and the first two columns. Drag the horizontal gray bar to just below row 1 and the vertical one to just past column B, as in the drag-and-drop steps above. Or go to View > Freeze and choose 1 row, then open the same menu again and choose 2 columns.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-6-1.png” alt=”Freeze rows and columns in Google Sheets \u2014 gray freeze bars below row 1 and to the right of column B” title_text=”Gray freeze bars below row 1 and to the right of column B” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now when we scroll across or down the spreadsheet, these rows and columns are locked in place. I can now easily compare the January data to the December data.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Freeze-GS-\u2013-3.png” alt=”Freeze rows and columns in Google Sheets \u2014 Page and January visitors columns next to December visitors after scrolling right” title_text=”Page and January visitors columns next to December visitors after scrolling right” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, the drag-and-drop option allows you to freeze as many rows or columns as you like, as long as they are immediately next to each other.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-freeze-a-row-in-the-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Below, you have instructions on how to freeze rows or columns in the Google Sheets mobile app using two different methods.<\/p>\n 1.<\/strong> In the Google Sheets mobile app, click on the row or column you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-row-google-sheets-app-select-row.webp” alt=”Freeze a row in the Google Sheets mobile app \u2014 row 1 selected” title_text=”Row 1 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Tap on the row or column header to see the menu and select \u2018Freeze row\u2019 or \u2018Freeze column\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-row-google-sheets-app-freeze-row.webp” alt=”Freeze a row in the Google Sheets mobile app \u2014 Freeze row in the menu above the selected row” title_text=”Freeze row in the menu above the selected row” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> The row, in this case, will remain visible no matter how far down you scroll.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-row-google-sheets-app-row-frozen.webp” alt=”Freeze a row in the Google Sheets mobile app \u2014 header row on top after scrolling down to row 14″ title_text=”Header row on top after scrolling down to row 14″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> You can freeze columns using the same method.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-column-google-sheets-app-freeze-column.webp” alt=”Freeze a column in the Google Sheets mobile app \u2014 Freeze column in the menu for column A” title_text=”Freeze column in the menu for column A” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can use the tab menu to specify the number of rows and columns you want to freeze.<\/p>\n 1.<\/strong> In the mobile app, tap on the tab or sheet name to see the menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-rows-google-sheets-app-sheet-tab-menu.webp” alt=”Freeze rows in the Google Sheets mobile app \u2014 Sheet1 tab menu with Freeze rows and Freeze columns at 0″ title_text=”Sheet1 tab menu with Freeze rows and Freeze columns at 0″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Use the arrows to indicate the number of rows and columns you want to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/freeze-rows-google-sheets-app-freeze-rows-arrows.webp” alt=”Freeze rows in the Google Sheets mobile app \u2014 up arrows setting Freeze rows and Freeze columns to 1″ title_text=”Up arrows setting Freeze rows and Freeze columns to 1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Unfreezing rows or columns is easy – simply reverse the process of your chosen method.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Hover your mouse over the gray-colored freeze panes. Once the hand icon appears, simply click and drag the gray pane back to the top left-hand corner of the spreadsheet.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To unfreeze your rows and columns using the Freeze feature, simply head to View > Freeze > No rows<\/b>, or, No columns<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-10-1.png” alt=”Unfreeze rows and columns in Google Sheets \u2014 Freeze submenu with No rows and No columns at the top of each group” title_text=”Freeze submenu with No rows and No columns at the top of each group” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-lock-a-row-or-column-in-place” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In Google Sheets, keeping a row or column on screen while you scroll is called freezing, so the steps above are all you need. To stop other people from changing it, protect it instead. Here’s how to lock cells so other people can’t edit them<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nWhat freezing rows and columns does in Google Sheets<\/h2>\n
\n
\n
How to freeze a row or column: drag-and-drop shortcut<\/h2>\n
How to freeze the top row or first column from the View menu<\/h2>\n
How to freeze a row or column in Google Sheets: right-click menu<\/h2>\n
How to freeze multiple rows or columns<\/h2>\n
Drag-and-drop shortcut<\/h3>\n
View menu<\/h3>\n
Right-click menu<\/h3>\n
How to freeze rows and columns at the same time<\/h2>\n
How to freeze a row in the Google Sheets mobile app<\/h2>\n
From the row or column header<\/h3>\n
From the tab or sheet name<\/h3>\n
How to unfreeze rows and columns<\/h2>\n
Option 1: Unfreeze rows and columns with the drag-and-drop method<\/h3>\n
Option 2: Unfreeze rows and columns via the View menu<\/h3>\n
How to lock a row or column in place<\/h2>\n
Conclusion<\/h2>\n
![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerows1.png\")
\n\nWhile being able to have all the data in one place is good, navigating within the cells can get challenging can be time-consuming. For example, I wanted to check the sales numbers in the month of March 2016. To do that, I will just move the horizontal scroll bar to the right until I am able to see the column corresponding to March 2016. But the problem is I won't be able to see the sales persons names as a result of scrolling. So we do not exactly see who sold how much in March 2016. Thus, moving the scroll bar is ineffective.\n\nExample<\/strong> ![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerows2.png\")
\n\nThe same applies in the vertical dimension as well. For example, I want to see how Michelle Haynes performed. I'll have to move the vertical scroll bar to reach the row where this particular sales person is present. Once we are there, we will notice that this time around, the month headers went missing. Thereby making it difficult to correlate which sales figures corresponding to which month.\n\nExample<\/strong> ![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerows3.png\")
\n\n \n![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerow4.png\")
\n\nWhen we hover the mouse pointer onto those grey colored panes, it turns into a hand icon. It is then we have to drag the vertical pane to the right just after the first column. similarly, drag the horizontal pane down until it clears just row # 2. The result will be as shown in the image below.\n\nExample<\/strong> ![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerow5.png\")
\n\nNow, if we try and scroll in any direction, the frozen rows remain intact. This will make reading the data much easier. Let's try this out. We move to the column corresponding to March 2016, and to the row belonging to Michelle Haynes. And, we'll notice the first column and first two rows are intact even though other rows and columns have shifted.\n\nExample<\/strong> ![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerow6.png\")
\n\n \n![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerows7.png\")
\n\nThen, we'll freeze the first column by navigating to View<\/strong> > Freeze<\/strong> > 1 column<\/strong>.\n\nExample<\/strong> ![\"Freeze](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/freezerowa8.png\")
\n\n \n\nWe 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. The number of rows or columns to freeze may vary depending upon the extent to which the useful information is present.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[55,39,28],"class_list":["post-5635","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/5635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=5635"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/5635\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/38047"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=5635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=5635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=5635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}