How to use Freeze Panes in Excel
This tutorial will explain us regarding freeze panes in Excel. When we have lot of data working with it is difficult to compare information in workbook. Excel includes several tools to make it easier to view the content and Freeze Panes is one the function.
When we scroll down we see that the header will disappear from the screen. To avoid such we freeze the panes so that we can compare the data and even understand it. The same when we scroll the spreadsheet horizontally the name of the company disappears so to avoid such we freeze the column.
Special Offer for First Time Users
If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.
👉 How to Freeze Top Row in Excel?
The Freeze panes in Excel provides us with three functions. Freeze Top Row in excel is one of the function of Freeze Panes.
Here the top most row of the Excel spreadsheet is freeze. That is Row 1 is freeze and now if you move your spreadsheet down the top row won’t move and you can see it at the top of the screen. However it is not always necessary that the header will be the first row of the spreadsheet. So this function won’t be of that use when you don’t have header on the first row.
Keep in mind that if you want to freeze first row you need to select second row and select freeze.
👉 How to Freeze first Columns in Excel?
If you want to freeze just the first column in Excel then you can select this function. Selecting this command will freeze your first column and now you are able to move horizontally in the excel spreadsheet.
Keep in mind that if you want to freeze first column you need to select second column and select freeze.
👉 How to Freeze both Column and Row Together?
If you want to freeze both row and column, you need to freeze them at the same time. Suppose you want to free the top two rows in the spreadsheet then you need to select A3 and select freeze pane. And you want to even freeze the first column then you need to select column B and select freeze pane. In this way you will freeze both row and column at the same time.
Keep in mind that while freezing both the row and column you need to select the cell which intersects both the row and column and click of freeze pane. This is the most used function other than the two i.e. freeze top row and freeze first column.
👉 How to You Unfreeze the Freeze Panes in Excel?
To unfreeze pane you need to go to the Freeze Panes and select unfreeze. This will unfreeze all the panes that you had freeze earlier. This will make your data look as it used to before applying freeze panes.
👉 Where do you find Freeze panes function in Excel?
Freeze pane function is found in the VIEW tab > Window group > freeze tab. As you click on the drop down menu you will find three options to freeze pane. Select the option and your row or column will freeze.
👉 Excel Shortcut keys for Freeze Panes
There is no specific shortcut to freeze pane. But you can freeze pane with the help of keyboard by carrying out following steps:
Step 1: Press Alt to activate the tab menu.
Step 2: Press W to open the view ribbon.
Step 3: Press F to open the freeze pane drop down menu.
Step 4: Select the option and press Enter.
We must note that freezing panes won’t have any effect while printing the workbook. It is just used for viewing in the worksheet. Hence with the help of this function scrolling becomes easier and the view of data is also proper. The video clearly shows how helpful this function is when we have large amount of table spread in the spreadsheet.
Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.
Learn 100+ Excel Tips & Tricks