How To Freeze Multiple Rows In Excel

Freezing a few rows at a time can make memorizing information much easier, keep reading to learn how you can use this incredibly beneficial feature of Excel!

How to freeze multiple rows in Excel

Last Updated on

Freezing rows in Excel can be a great idea when you have so much information on a spreadsheet and need certain data to remember while you continue working.

Freezing a row will allow it to stay on the screen no matter how far you scroll and is a great built-in feature to Excel that will prevent any need for you to write down any equations or statistics vital to the end result.

Excel also lets you freeze not just one row but multiple, meaning you can pin bulks of information to the screen making it far easier to keep track of your findings so far and always have the relevant data and equations at the ready.

Freezing multiple rows at the same time is made incredibly easy with Excel simply requiring you to toggle through a few options and menus, so here is how to quickly freeze multiple Excel rows in no time.


Windows And MacOS

Excel is available for both Mac and Windows PC’s with many of the features being very similar, and luckily this is the same for freezing columns and rows.

Also keep in mind that Excel Starter leaves out a lot of features of the normal Excel and this includes freezing, so make sure you are using the normal version of Excel to be able to freeze several rows at a time.



Highlight Row

When you open up the Excel document you want to start editing, click on the row you want to freeze.

The way this works is if you highlight a row, all others rows above it will be frozen so 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.



Click View Tab

When you have chosen the rows 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.



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 drop down a menu.



Choose To Freeze Rows

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.



Unfreeze Rows

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’.


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 and is part of the reason it has become the most popular spreadsheet platform because of its incredible versatility and ease of use.