How to Freeze Excel Row or column?
What is the use of Freeze Pane in Excel
When we have large data in Excel Sheet, by freezing the first row, you can ensure that the headers remain in view, making it easier to understand the contents of each column as you navigate through the spreadsheet.
How to access the Freeze Pane Option in Excel
Go to View Tab in Excel
Search Windows Category in View Tab. You will get the Freeze Pane Option here as shown in the below picture
There are three options here
- Freeze Panes: Select any Cell, It will freeze all Rows above and Left side Columns from Selected Cell
- Freeze Top Row: It will Freeze the Top Row while scrolling the data downside
- Freeze First Column: It will Freeze the First Column while scrolling the data to the right side
Freeze Row Or Rows in Excel
Select this option to freeze the row or rows only
Freeze Top Row only in Excel
Sometimes we have data with thousand of rows with header in the first row, we have to scroll down to see the data but the first row gets invisible. We can freeze the first row of the header part in Excel for better visibility of the data with the header.
In this case, select the Second option from the Freeze Pane in the Excel
Lock More than one Row or Rows in Excel
Let’s say we have data with a header and Heading part, Now we want to lock or freeze the first row with the top heading of the data, in this case, we will select the cell of the first column, then select the first option from the Freeze Pane option.
Unfreeze Row or Rows in Excel
Once you have done your work, now you want to unfreeze the pane, simply go to the view tab and select the Freeze Pane option, then you will get unfreeze option in the same windows. Click on that. That’s all.
Freeze Column or Columns In Excel
In this section, we will learn how to freeze column in excel
Freeze or Lock First Column in Excel
Select this option to freeze the first column of the excel worksheet.
Unfreeze Column or Columns in Excel
Once you have done with your work, select view tab, select unfreeze column option to unfreeze the Column
Freeze or Lock More than one Column with Row in Excel
Select the firsct cell in next column you want to freeze. Select Freeze Pane (First Option) to freeze the column or columns in the Excel file.
Freeze Both Rows and Columns in Excel
Select the cell after the Row or Column where you want to freeze the Rows and columns of the sheet. Select the First Option in the Freeze Pane to freeze the column and row.