How to Freeze Panes in Excel: A Step-by-Step Guide

If you’re working with large amounts of data in Excel, you might find it difficult to keep track of everything. Fortunately, Microsoft Excel offers a feature called Freeze Panes, which allows you to lock certain rows or columns in place while you scroll through the rest of the worksheet. In this article, we’ll show you how to freeze panes in Excel, step-by-step.

Step 1: Open Your Excel File

The first thing you need to do is open the Excel file you want to work on. If you don’t have one yet, you can create a new one by clicking the “New Workbook” button on the Excel start screen. Once you have your file open, you can move on to the next step.

Excel IconSource:

Step 2: Select the Rows or Columns You Want to Freeze

Next, you need to select the rows or columns you want to freeze. To do this, simply click on the cell in the row or column you want to freeze. If you want to freeze multiple rows or columns, click and drag your mouse to select them.

Select Rows In ExcelSource:

Step 3: Click on the “View” Tab

Once you’ve selected the rows or columns you want to freeze, click on the “View” tab at the top of the Excel window. This will open up the View tab options.

View Tab In ExcelSource:

Step 4: Click on the “Freeze Panes” Button

In the View tab options, you’ll see a button called “Freeze Panes”. Click on this button to open up the Freeze Panes options.

Freeze Panes Button In ExcelSource:

Step 5: Select the “Freeze Panes” Option

Once you’ve clicked on the Freeze Panes button, you’ll see three options: “Freeze Panes”, “Freeze Top Row”, and “Freeze First Column”. To freeze the rows or columns you selected earlier, click on the “Freeze Panes” option.

Freeze Panes Options In ExcelSource:

Step 6: Scroll Through Your Worksheet

Now that you’ve frozen your rows or columns, you can scroll through the rest of your worksheet without losing sight of the information you need to keep track of. You’ll notice that the frozen rows or columns stay in place while the rest of the worksheet scrolls.

Scroll In ExcelSource:

Step 7: Unfreeze Panes

If you need to unfreeze your panes, simply click on the “View” tab, click on the “Freeze Panes” button, and select “Unfreeze Panes”. This will unfreeze any rows or columns you have frozen.

Unfreeze Panes In ExcelSource:


Freezing panes is a useful feature in Excel that can help you keep track of important information while working with large amounts of data. By following the steps outlined in this article, you should be able to easily freeze and unfreeze rows or columns in Excel.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *