How to Freeze Cells in Excel?
Many times we need to see certain rows & columns throughout the worksheets specifically the header cells. We can achieve such type of locking of excel cells by using the freezing feature. By freezing the rows and columns cells in one place we can scroll through the worksheet while continuing to view the frozen cells.
Examples to Freezing Rows and Columns Cell in Excel
Let us understand how to freeze rows and columns in excel by a simple example first.
Freeze Rows and Columns Cell – Example #1
Freezing the Rows: Given below is a simple example of a calendar.
Step 1: We need to select the row which we need to freeze cell by clicking on the number of the row.
Step 2: Click on the view tab on the ribbon. We need to select the freeze panes command on the view
Step 3: The selected rows get frozen in its position & it is denoted by a grey line. We can scroll down the entire worksheet & continuing viewing the frozen rows at the top. As we can see in the snapshot below, the rows above the grey line are frozen and do not move after we scroll the worksheet.
The same process can be repeated for unfreezing the cells. Once we have frozen the cells the same command is changed in the view tab. The ‘Freeze Panes’ command is now changed to ‘Unfreeze Panes’ command. By clicking on it the frozen cells are unfrozen. This command unlocks all the rows & Columns to scroll through the worksheet.
Freezing the Columns: Considering the same example of a calendar, we can freeze the Columns cell as well repeating the same process.
In this example, the date is provided in the columns instead of the rows.
Step 1: We need to select the Columns which we need to freeze excel cells by clicking on the alphabet of the column.
Step 2: After selecting the columns we need to click on the view tab on the ribbon. We need to select the freeze panes command on the view tab.
Step 3: The selected columns get frozen in its position & it is denoted by a grey line. We can scroll the entire worksheet & continuing viewing the frozen Columns. As we can see in the snapshot below, the columns beside the grey line are frozen and do not move after we scroll the worksheet.
For unfreezing the columns we use the same process as we did in the case of Rows i.e. by using the unfreeze panes command from the view tab. There are other two commands as well in the Freeze panes options which are ‘Freeze Top Row’ & ‘Freeze First Column ’.
These commands are used only for freezing the top row and the first column respectively. The ‘Freeze Top Row’ command freezes the row number ‘1’ & the ‘Freeze First Column’ command freezes the column number A cell. It is to be noted that we can freeze Rows as well as columns together also. It is not necessary that only the row or the column can be locked at a single instance.
Freeze Rows and Columns Cell – Example #2
Let us take an example of the same.
Step 1: The sheet below shows the time sheet of a company. The columns contain the headers as Day, Date, Regular Hours, Overtime Hours, Sick, Vacation & Total.
Step 2: We need to see the Column ‘B’ as well as the Row 7 throughout the worksheet. We just have to select the cell above and besides which we need to freeze the Columns & Rows Cells respectively. In our example, we just have to select the cell number H4.
Step 3: After selecting the cell we just need to click on the view tab on the ribbon & select the ‘Freeze Panes’ command on the view tab.
Step 4: As we can see from the snapshot below, there are two grey lines denoting the locking of cells.
Use of Rows & Column Freezing in Excel Cell
If we use the Freezing Panes command to freeze the columns and rows excel cell they would remain displayed on the screen regardless of the magnification settings that we select or how we scroll through the cells. Let us take a practical example of the Weekly attendance report of a class.
Step 1: Now if we take a look at the snapshot below, the Rows & Column display various pieces of information such as Student Name, name of the days. Subject Codes etc. the topmost column shows the Logo and the name of the School.
In this case, it becomes a necessity to freeze certain excel columns and rows cells for understanding the Attendance the reports otherwise the report itself becomes Vague & Difficult to understand.
Step 2: We simply Select the cell at the F4 Location as we need to freeze down the rows up to the subject code P1 T1 U1 E1 & so on and Columns up to the ‘student name’.
Step 3: Once we have selected the Cell we just have to use the Freeze Panes command which freezes the cells at the position indicating a grey line.
As a result of this, we can see that the rows and columns beside and above the selected cell have been freeze as shown in the snapshots below.
Similarly, we can use the ‘Unfreeze Pane’ command from the View tab to unlock the cells which we have frozen.
Hence with the explanation of examples above we make use of freezing of rows and columns in excel.
Things to Remember
- When we press the Control + Home Excel Shortcut keys after giving the Frozen Panes command in a worksheet. Instead of positioning the cell cursor in cell A1 as normal, excel positions the cell cursor in the first unfrozen cell.
- Freeze Panes in the worksheet cell display consists of a feature for printing a spreadsheet known as Print Titles. When we use Print Titles in a report, the columns and rows that we define as the titles are printed at the top and to the left of all data on each page of the report.
- The Short cut keys used for getting spontaneous access to the Freezing Panes command is Alt + WF.
- It is to be noted that in case of Freezing Excel Rows & Columns together we just have to select the Cell Above & besides which the Rows & Columns need to be freeze. We don’t have to Select the entire row & the Entire Column together for locking.
You can Download this Freeze Rows and Columns Excel Cell template here – Lock Rows and Columns Excel Template
This has been a guide to Freeze Cells in Excel. Here we discuss how to freeze rows and columns using Freeze Panes in excel with some examples and downloadable excel template. You may learn more about excel from the following articles –
- Examples of Print in VBA Excel
- Excel Rows Function
- How to Find Excel Column to Number?
- Change Text Case in Excel
- Excel Running Total
- Split Panes in Excel
- Hiding an Excel Column
- Unhide Columns in Excel
- Column Lock in Excel
- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion
- Basic Excel Training
- Advanced Excel Training
- Basic & Advanced VBA Course
- Excel Dashboard Course
- Data Analysis in Excel
- Create VBA Applications