/>
X
Innovation
Why you can trust ZDNET : ZDNET independently tests and researches products to bring you our best recommendations and advice. When you buy through our links, we may earn a commission. Our process

'ZDNET Recommends': What exactly does it mean?

ZDNET's recommendations are based on many hours of testing, research, and comparison shopping. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing.

When you click through from our site to a retailer and buy a product or service, we may earn affiliate commissions. This helps support our work, but does not affect what we cover or how, and it does not affect the price you pay. Neither ZDNET nor the author are compensated for these independent reviews. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers.

ZDNET's editorial team writes on behalf of you, our reader. Our goal is to deliver the most accurate information and the most knowledgeable advice possible in order to help you make smarter buying decisions on tech gear and a wide array of products and services. Our editors thoroughly review and fact-check every article to ensure that our content meets the highest standards. If we have made an error or published misleading information, we will correct or clarify the article. If you see inaccuracies in our content, please report the mistake via this form.

Close

How to freeze a row in Excel

Scrolling through an Excel spreadsheet that has dozens of rows can get tedious, but freezing rows helps make it a much simpler process.
maria-diaz
Written by Maria Diaz, Staff Writer on

We already scroll enough on our phones, so scrolling down a mile-long spreadsheet only to end up losing your place from the headers is a hassle. We don't always use the top row as the header on a table, so freezing the second or third row may be a necessity to always keep information visible.

Or maybe you want to quickly compare data from two rows that are pages apart. This is where freezing rows will help you get to a more organized spreadsheet.

Also: How to create a drop-down list in Excel

How to freeze rows in Excel

How to freeze rows in Excel
Image: Maria Diaz / ZDNet

Step 1: Select the row below the one you want to freeze

Select the row below the one you want to freeze
Image: Maria Diaz / ZDNet

If your table's header is on row 3, then select row 4. The row above the one selected is the one that will freeze. 

Step 2: Go to View and click Freeze panes

Click on View and Freeze Panes
Image: Maria Diaz / ZDNet

That's it!

FAQs

How can I freeze a column?

Excel can automatically freeze the first column on a spreadsheet by clicking the Freeze First Column button under View. But if you want to freeze another column, just select the one to the right of where you want to freeze it and click on Freeze Panes.

How can I use this to compare information?

The same steps apply to freezing a row below the header. To compare row 12 with row 87, select row 13 and click on Freeze Panes. Everything above row 13 will be frozen, so row 12 stays visible while you scroll down to row 87.

Can I unfreeze panes in Excel?

Excel has a button that allows users to unfreeze panes. Click on View, and the Unfreeze Panes button will be where Freeze Panes once was. 

Editorial standards

Related

How to get Microsoft Office for free
zd-microsoft-office.jpg

How to get Microsoft Office for free

Convert documents to and from PDFs for a lifetime for only $30
replace-this-image.jpg

Convert documents to and from PDFs for a lifetime for only $30

How to set a reminder in Slack with the help of Slackbot
Slack's notification after creating a reminder.

How to set a reminder in Slack with the help of Slackbot