Let\u2019s explore in more detail why it may be helpful to freeze rows and columns in your Google Sheets, and how you can freeze them in your spreadsheets in just a few easy steps.<\/p>\n
[\/et_pb_text][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.4″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”255434″ theme_builder_area=”post_content”]<\/p>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n
![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\n
One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n Find out how<\/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 free 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 _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/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 0″ title_text=”Web 1920 \u2013 15″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 By doing this, I will be able to reduce the time I take to effectively compare the difference in web page visitors over the year, thus improving my productivity and efficiency.<\/p>\n There are two main ways that you can freeze your rows and columns in Google Sheets:<\/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 _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This is a simple shortcut where you can drag and drop the freeze panes directly to the rows or columns you wish to pin.<\/p>\n On the top left-hand corner of your Google Sheets spreadsheet, you will find both a vertical and horizontal gray pane as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-5-1.png” alt=”freeze rows and columns in Google Sheets 1″ title_text=”Web 1920 \u2013 5″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 When you hover your mouse over those gray-colored panes, it turns into a hand icon. Simply drag each pane either vertically or horizontally until they sit below the columns or rows you wish to freeze.<\/p>\n Using my example, let\u2019s freeze the first row and the first 2 columns in my spreadsheet.<\/p>\n It should look like this.<\/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 2″ title_text=”Web 1920 \u2013 6″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 3″ title_text=”Freeze GS \u2013 3″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We can also use the Freeze feature located in the View menu to accomplish the exact same thing.<\/p>\n The Freeze feature offers different ways to freeze a certain number of rows or columns within your spreadsheet.[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In order to freeze the first row of your data, simply head to View > Freeze > 1 row<\/b>. <\/p>\n Alternatively, to freeze the first column of your data, head to View > Freeze > 1 column<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Freeze-GS-\u2013-4.png” alt=”freeze rows and columns in Google Sheets 4″ title_text=”Freeze GS \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” 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 After doing both, your spreadsheet will look like this.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Freeze-GS-\u2013-5.png” alt=”freeze rows and columns in Google Sheets 5″ title_text=”Freeze GS \u2013 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” 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 In order to freeze the first two rows or columns of your data, follow the same instructions as above, clicking the 2 rows<\/b> or 2 columns<\/b> options instead.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/Freeze-GS-\u2013-6.png” alt=”freeze rows and columns in Google Sheets 6″ title_text=”Freeze GS \u2013 6″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 After doing both, your spreadsheet will look like this:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-6-2.png” alt=”freeze rows and columns in Google Sheets 7″ title_text=”Web 1920 \u2013 6″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 Finally, to freeze multiple rows or columns of your data, you must start by highlighting the row or column that you wish to freeze.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-11-1.png” alt=”freeze rows and columns in Google Sheets 8″ title_text=”Web 1920 \u2013 11″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 Then navigate to View > Freeze > Up to current row<\/b>, or, Up to current column<\/b>.<\/p>\n The number or letter of your highlighted column should be within brackets next to each option.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-12-1.png” alt=”freeze rows and columns in Google Sheets 9″ title_text=”Web 1920 \u2013 12″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 Once you\u2019ve applied these steps to both your rows and columns within the spreadsheet, it should look something like this:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/Web-1920-\u2013-13-1.png” alt=”freeze rows and columns in Google Sheets 10″ title_text=”Web 1920 \u2013 13″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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=”freeze rows and columns in Google Sheets 11″ title_text=”Web 1920 \u2013 10″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” 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 And there you have it! Managing large amounts of data can become even easier if you freeze the important rows or columns of your data in place.<\/p>\n Interested in learning more about the various functions and features of Google Sheets? Take a look at more blog posts filled with the latest tips and tricks to improve the efficiency of your work in spreadsheets<\/a>.<\/p>\n Alternatively, check out more blog posts by Sheetgo below!<\/p>\n [\/et_pb_text][et_pb_code _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Why freeze rows or columns in Google Sheets?<\/h2>\n
\n
\n
How to freeze rows or columns in Google Sheets<\/h3>\n
\n
1. Drag and drop panes to freeze rows or columns of data<\/h4>\n
2. Use the Freeze feature in the View menu to freeze rows and columns<\/h4>\n
Freeze the first row or column of your data<\/h5>\n
Freeze the first 2 rows or columns of your data<\/h5>\n
Freeze multiple rows or columns of your data<\/h5>\n
How to unfreeze rows or columns in Google Sheets<\/h4>\n
Option 1: Unfreeze rows and columns with the drag-and-drop method<\/h5>\n
Option 2: Unfreeze rows and columns via the View menu<\/h5>\n
Freezing rows and columns in Google Sheets<\/h3>\n