How to Freeze Headers in Excel
Posted By: Ryan Richardson - 9/29/2021 12:00:00 AM

Excel is great for reviewing data, but when you can’t see the column or row headers, it can be frustrating to scroll back and forth to check what the data means. Did you know there’s a great time saver which can lock the headers in place? Here’s how to do it.

How to freeze a header in Excel:

  1. Select View

  2. In the Window section, click the Freeze Panes drop down menu

  3. Choose between freezing the top row, first column, or both 

That’s all there is to it. Now you can say goodbye to scrolling back and forth and second-guessing which row or column you’re looking at.


Run Business Solutions is an IT managed services and website services provider based in Amarillo, TX. We support small to mid-sized businesses both regionally and throughout the country. We pride ourselves on helping businesses leverage technology, not just tolerate it. Runbiz is focused on enthusiastically providing excellent technical strategy, services, and solutions that drive our customers' businesses forward. We are passionate about our mission to empower you to do what you do best. 

To learn more about our approach to IT, visit our Managed IT or Co-Managed IT pages. If you are looking to revamp your website to look and perform better, visit our website services for more information.

To speak to a member of our team, fill out the consultation form! We would love to learn more about your company, your technology needs, and how we can address the unique challenges you face.