How to freeze rows and columns in Excel – our step-by-step guide
Table of Contents
If you want to learn how to freeze rows and columns in Excel, then you’ve landed on the right page.
Freezing rows or columns in Excel can be a great idea when you have a lot of information on a spreadsheet and need to remember certain data while you continue working. Freezing a row or column will allow it to stay on the screen no matter how far you scroll, and it is a great built-in feature that will prevent you from writing down equations or statistics vital to the end result.
Prime Day may have closed its doors, but that hasn't stopped great deals from landing on the web's biggest online retailer. Here are all the best last chance savings from this year's Prime event.
- Sapphire Pulse AMD Radeon™ RX 9070 XT Was $779 Now $719
- AMD Ryzen 7 7800X3D Processor Was $449 Now $341
- Skytech King 95 Ryzen 7 9800X3D gaming PC Was $2,899 Now $2,599
- LG 77-Inch Class OLED C5 TV Was $3,696 Now $2,996
- AOC Laptop Computer 16GB RAM 512GB SSD Was $360.99 Now $306.84
- Lexar 2TB NM1090 w/HeatSink SSD Was $281.97 Now $214.98
- Apple Watch Series 10 GPS+ Smartwatch Was $499.99 Now $379.99
- AMD Ryzen 9 5950X processor Was $3199.99 Now $279.99
- Garmin vívoactive 5 Smartwatch Was $299.99 Now $190
*Prices and savings subject to change. Click through to get the current prices.
As the option to freeze rows and columns is hidden behind a layer of settings, we’ll walk you through the entire process to make things easier for you.
Here’s how to freeze a row or column in Excel
If you want to freeze rows or columns, follow these steps.
Step
Highlight a row or column
When you open up the Excel document you want to start editing, click on the row or column you want to freeze.
The way this works is if you highlight a row or column, all others rows above or columns on the side will be frozen. For example, if you choose row 5, the 4 previous rows will also be frozen on your screen, allowing you to get a bulk of information saved at once.
Step
Click on the View tab
When you have chosen the rows or columns you want to freeze, there will be a handful of options at the top that you can click on.
Each has their own set of tools that can be used to format a sheet in different ways and can really open up all the potential features an Excel user has at their disposal.
The option you will want to click on is ‘View' near the far right of the screen.
Step
Select Freeze Panes
Once the ‘View' menu has been selected, look to the far right at the top of the screen to see a ‘Freeze panes' option. Click on the small arrow beside it to open a drop-down menu.
Step
Choose to freeze rows/columns
You will be offered three options, two of which are to only freeze the top row or first column.
Instead, click the first option simply called ‘Freeze Panes' to tell Excel to freeze only the rows that had been selected previously.
Step
How unfreeze works
Your rows of choice will now be frozen and be easy to see as you navigate the page.
If you ever feel the rows are a bit too cumbersome or you don't need them anymore, simply go on the same ‘Freeze Panes' drop-down menu and click ‘Unfreeze Panes'.
Conclusion
Freezing multiple rows at a time is a quick and easy way to keep a few crucial bits of information memorized and ready to go whenever you may need them throughout your work. Excel makes this function extremely easy to toggle on and off, which is part of the reason it has become the most popular spreadsheet platform.
If you want to learn more about Excel and how it works, give these guides a read: