Freeze rows and columns in Excel (Easy tutorial)
When working with complicated Excel spreadsheets that have dozens of rows or columns, you may need to pin the row and/or column headers to make them stay on the screen, so that you will be able to see the headers even when you scroll away (see below left picture). Or maybe you just want to quickly compare two different sets of data that are widely separated (see below right picture). These cases are where freezing rows / columns can help you.
How to freeze rows in a worksheet
In this section, I will teach you how to keep rows of a worksheet visible when you scroll to another area of the worksheet with Excel’s built-in functionality.
Freeze top row
Step 1: Select View > Freeze Panes > Freeze Top Row
Result
Freeze multiple rows
Step 1: Select the row (or the first cell in the row) below the row you want to freeze
For example, if your header is on row 4, then select row 5, or the first cell in row 5, which is cell A5.
Step 2: Select View > Freeze Panes > Freeze Panes
Result
How to freeze rows across all worksheets
With Excel’s built-in Freeze Panes feature, you can only freeze rows in one worksheet, which could make it tedious if you have a large number of worksheets with the same specific rows to freeze. In order to freeze rows across all worksheets quickly and easily, you can use the help of Kutools for Excel’s Freeze Panes Multiple Worksheets feature.
Step 1: Select the row (or the first cell in the row) below the row you want to freeze
For example, if you want to freeze the top row, select row 2, or the first cell in row 2, which is cell A2; if your header is on row 4, then select row 5, or the first cell in row 5.
Step 2: Select Kutools Plus > Worksheet > Freeze Panes Multiple Worksheets
Result
The same rows across all worksheets in the active workbook are pinned at the top in no time.
How to freeze columns in a worksheet
Now, let’s learn how to lock the Excel columns, so that you can see which rows the values correspond with when you scroll to the right.
Freeze first column
Step 1: Select View > Freeze Panes > Freeze First Column
Result
The leftmost column is now visible even when you scroll to the right.
Freeze multiple columns
If you want to freeze more than one column, please do as follows:
Step 1: Select the column (or the first cell in the column) to the right of the column you want to freeze
For example, if you want to pin the first two columns, you should select column C, or the first cell in column C, which is cell C1.
Step 2: Select View > Freeze Panes > Freeze Panes
Result
How to freeze columns across all worksheets
Instead of locking columns for each sheet one by one, you can also use Kutools for Excel’s Freeze Panes Multiple Worksheets feature to batch freeze columns across all worksheets in the active workbook.
Step 1: Select the column (or the first cell in the column) to the right of the column you want to freeze
For example, to freeze the leftmost column, select column B, or the first cell in column B, which is cell B1; to freeze the leftmost 2 columns, select column C, or the first cell in column C.
Step 2: Select Kutools Plus > Worksheet > Freeze Panes Multiple Worksheets
Result
The same columns in all worksheets of the active workbook are frozen immediately.
How to freeze rows and columns in a worksheet
To lock one or more rows and columns at a time, please do as follows:
Step 1: Select a cell below the last row and to the right of the last column you want to freeze
For example, to pin the top 4 rows and first 2 columns, select the cell below the row 4 and to the right of column B, which is the cell C5.
Step 2: Select View > Freeze Panes > Freeze Panes
Result
How to freeze rows and columns across all worksheets
To freeze rows and columns across all worksheets, you can use Kutools for Excel's Freeze Panes Multiple Worksheets feature, which enables you to freeze rows and columns across all worksheets with few clicks.
Step 1: Select a cell below the last row and to the right of the last column you want to freeze
For example, to lock the top 4 rows and leftmost 2 columns, select the cell below the row 4 and to the right of column B, which is cell C5.
Step 2: Select Kutools Plus > Worksheet > Freeze Panes Multiple Worksheets
Result
The exact rows and columns in all worksheets are frozen right away.
How to unfreeze rows and columns in a worksheet
If you do not want to freeze rows and/or columns in the current worksheet anymore, tab View > Freeze Panes > Unfreeze Panes.
How to unfreeze rows and columns across all worksheets
To unfreeze rows and/or columns across all worksheets in bulk, click Kutools Plus > Worksheet > Unfreeze Panes Multiple Worksheets.
Related articles
- How to freeze top and bottom row at once in Excel?
- In Excel, we can easily freeze top row of a worksheet. Sometimes, there is a large worksheet has long list data, and we want to freeze both the top row and bottom row, so that we can view the top headers row and last row at the same. There is no direct way for us to solve this problem, fortunately, we can use some workaround ways to deal with this task.
- How to apply freeze / unfreeze panes to multiple worksheets at once?
- Supposing you have a large workbook which contains hundreds of worksheets, and now you need to apply the Freeze Panes to freeze all of the worksheets at once. With Excel’s Freeze Panes function, you can just freeze only one worksheet at a time, is there a way to freeze or unfreeze all worksheets immediately at once in Excel?
- How to lock or freeze worksheet tab in Excel?
- Supposing you have a workbook which contains multiple worksheets, there is a worksheet named Main-sheet as the first tab in the workbook. And now, you want to try to lock or freeze this sheet tab to make it always visible even when scrolling across a number of worksheets. In fact, there is no direct way for you freeze the tab, but, you can use a workaround to deal with this problem.
- More tips and tricks for Excel...
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Table of contents
- Video: Freeze rows and columns in Excel
- How to freeze rows:
- In a worksheet
- Across all worksheets
- How to freeze columns:
- In a worksheet
- Across all worksheets
- How to freeze rows and columns:
- In a worksheet
- Across all worksheets
- How to unfreeze rows and/or columns:
- In a worksheet
- Across all worksheets
- Related Articles
- The Best Office Productivity Tools
- Comments