How to Freeze Rows and Columns in Excel

How to Freeze Rows and Columns in Excel

How to Freeze Rows and Columns in Excel


In this Microsoft Excel blog post we will tell you, how you can freeze a part of your Excel sheet, and scroll through the rest.
This option is called Freeze Panes in Excel, this option you will find in the View tab.

There are several ways to use this option as you can see in the option
Freeze Panes
Freeze top row
Freeze first column

How to freeze panes in excel

Freeze Panes to use this, you need to place your cursor where you need to freeze both the line and the column.
for example:

Now as you can see in the picture below, we have to freeze the first 3 lines and the first column so you can place your cursor on the cell B4 and then use the option of Freeze Panes.


How to freeze panes in excel

So now you can see if your first three lines and the first column are frozen and you can scroll through the rest of the Excel sheet.

How to freeze panes in excel

How to freeze a row in excel

Similarly, if you want to freeze the first 3 lines, you need to select the fourth line and then use the option of these Freeze Panes.


How to freeze a row in excel


You will now see if your first three lines are frozen and can easily scroll through the rest of the Excel sheet.

How to freeze a row in excel

How to freeze a column in excel

If you need to freeze two columns, select Column C and then use the Freeze Panes option.

How to freeze a column in excel

You will now notice that your first two columns have been frozen.
How to freeze a column in excel

How to freeze top row in excel

Freeze top row, It is clear that you can freeze the first line of your Excel sheet through this option.

How to freeze first column in excel

Freeze first column is also known by what option we can freeze the first column in our Excel sheet.


After understanding this Microsoft Excel trick, there will be answers to many questions that arise as
How to freeze a row in excel
How to freeze panes in excel
How to freeze cells in excel
How to lock a row in excel
How to freeze multiple rows in excel
How to freeze rows and columns in excel
How to freeze top row in excel
How to fix a row in excel
How to freeze top two rows in excel
How to freeze in excel

Post a comment

0 Comments