Table of Contents
What is Freeze Panes in Excel?
As you know Excel is very user-friendly software for daily business purpose data manipulation. If you have large data to compare information in your excel sheet, then excel provides freeze panes and split ability to view and compare your content in excel workbook.
Freeze rows and columns in excel is very useful if you have a large table this way you can keep rows and columns visible while scrolling. Suppose you need to scroll but you want to see a top row or left column to stay still then freeze pane is very useful for this.
How to Freeze Panes in Excel?
Let’s understand the working of freeze panes in excel by the below simple examples.
Example #1 – Freeze the Top Row in Excel
Let’s consider a sales data set as shown in the below table to apply the excel freeze panes to lock the first row from the below table.
Go to the view tab and then click on freeze top row in excel as shown in the below figure.
By selecting this option your entire sheet first row will freeze you can test it by scrolling the sheet.
Example #2 – Freeze the First Column in Excel
Let consider the same sales data to apply the excel freeze panes option on it.
Go to the view tab and then click on freeze first column option as shown in the below figure.
By selecting this option your entire first column will freeze. If you scroll the sheet to column-wise you will see that first column will not move while scrolling.
Example #3 – Freeze the Top Row and the First Column in Excel
In this example, we will apply the freeze panes option in excel on the top row and first column at once. Let’s consider the below table.
Select the B2 cell and Go to view tab and then click on freeze panes option as shown in the below figure.
Now you will see the top row and first column get the freeze.
Example #4 – Freeze as Many Rows or Columns in Excel as you want
In excel you can freeze as many rows or columns as you want using freeze panes option.
To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. To freeze multiple rows in excel (starting with row 1), select the row below the last row you want frozen and click Freeze Panes.
Example #5 – Unfreeze the Panes in Excel
If you have data on which the freeze pane is already applied but you don’t know where it is applied, then you can just simply remove the freeze pane by selecting the Unfreeze panes option under view tab as shown in the below figure.
Things to Remember about Freeze Panes in Excel
- You can use Alt-W-F short cut to enable the Freeze Panes options in excel sheet. Then there are three options:
- Press F to freeze both rows and columns in excel based on where your cursor is (this will freeze rows and columns to the right and to the left of your cursor)
- Press R to freeze the top row in excel only
- Press C to freeze the first column in excel only
You can download this Freeze Panes Excel template here – Freeze Pans Excel Template
This has been a guide to Freeze Panes in Excel Cell. Here we discuss how to freeze the Rows and Columns in excel using Freeze Panes along with the example and downloadable excel templates. You may also look at these useful functions in excel –