Learn how to freeze a row in Google sheets, as well as how to unfreeze it. This technique is the same for rows and columns.
While working on a longer spreadsheet, it can be helpful to see the first row with the information that identifies the contents of each column. By freezing the row, it will stay visible at the top of the screen as you scroll through the rest of the spreadsheet. You can freeze a row in Google Sheets if you need to reference the row's header while you examine the data further down the page.
In this tutorial, you will learn how to freeze a row or column in Google Sheets and how to unfreeze it.
professional certificate
Launch your career in Human Resources. In this program, you’ll learn in-demand skills for a career as an Human Resource Associate. No degree or prior experience needed. Coursera's 2024 Learners First Award Winner.
4.8
(2,005 ratings)
84,997 already enrolled
Beginner level
Average time: 5 month(s)
Learn at your own pace
Skills you'll build:
Employee Relations, Training development, Performance Management, Recruitment, Compliance strategy, Benefit types, Compensation strategy, Pay systems, Total rewards, Business Continuity, Employee Engagement, Learning Delivery Methods, Effective Training, Training Needs, Learning Models, Legal Compliance, Risk Management, Safety Compliance, Compliance Implementation, Employee Onboarding, Job Analysis, interviewing
You will be able to freeze the first rows of the spreadsheet. You can freeze more than one, but they must be at the beginning edge of the rows. If this poses an issue, you can re-sort your spreadsheet to get the appropriate row at the top.
To freeze a row in Google Sheets, select the row, click View > Freeze, and select the number of items you want to freeze. Let’s examine each of these steps in more detail.
Click on the row you wish to select. To ensure you select the entire row, click on the numbered box of the row.
Click View > Freeze.
Choose how many rows to freeze.
The process is very similar if you change your mind and need to unfreeze a row or column. To unfreeze a row in Google Sheets, you would return to the View menu and select Freeze > No rows. You can complete the same steps for frozen columns.
You may also need to unfreeze a row or column if you change the spreadsheet while editing, such as by removing or adding additional rows or columns.
Frozen rows won’t stay put: When you freeze multiple rows, the program creates a scroll bar to scroll through the rows you’ve frozen. If your frozen rows seem to move around, check to ensure you haven’t scrolled through them.
Frozen rows won’t print: To ensure frozen rows appear on printed documents, check your print and export settings. Look for an option similar to “Include frozen rows.”
To learn more about Google Sheets and working with data, consider earning your Google Data Analytics Professional Certificate. This beginner-level, eight-course series can help you learn skills in Google Sheets, data analysis, data cleansing, sample size determination, and more. After earning your certificate, you can connect with over 150 companies that recognize the certificate in Google’s Employer Consortium.
professional certificate
Get on the fast track to a career in cybersecurity. In this certificate program, you'll learn in-demand skills, and get AI training from Google experts. Learn at your own pace, no degree or experience required.
4.8
(39,136 ratings)
840,197 already enrolled
Beginner level
Average time: 6 month(s)
Learn at your own pace
Skills you'll build:
Python Programming, Security Information and Event Management (SIEM) tools, SQL, Linux, Intrusion Detection Systems (IDS), Packet Analyzer, Security Hardening, Network Security, Transmission Control Protocol / Internet Protocol (TCP/IP), Network Architecture, Cloud Networks, escalation, resume and portfolio preparation, stakeholder communication, Job preparedness, integrity and discretion, Cybersecurity, Information Security (INFOSEC), Ethics in cybersecurity, NIST Cybersecurity Framework (CSF), Historical Attacks, Computer Programming, Coding, PEP 8 style guide, NIST Risk Management Framework (RMF), Security Audits, Incident Response Playbooks, Authentication, vulnerability assessment, Cryptography, asset classification, threat analysis, Command line interface (CLI), Bash
Editorial Team
Coursera’s editorial team is comprised of highly experienced professional editors, writers, and fact...
This content has been made available for informational purposes only. Learners are advised to conduct additional research to ensure that courses and other credentials pursued meet their personal, professional, and financial goals.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.