Freeze Cells in Excel

How to Freeze Cells in Excel? (with Examples)

Freezing cells in excel mean that when we move down to the data or move up the cells, we freeze remains being displayed on the window. To freeze cells in excel, select the cells we want to freeze and then in the view tab in the windows section, click on freeze panes and click on freeze panes; this will freeze the selected cells. Let us understand how to freeze rows and columns in excel by a simple example first.

You can download this Freeze Rows and Columns Excel Cell template here – Freeze Rows and Columns Excel Cell template

Example #1

Freezing the Rows: Given below is a simple example of a calendar.

  1. We need to select the row, which we need to freeze the cell by clicking on the number of the row.


    Freeze Cells in Excel Ex. 1

  2. Click on the View tab on the ribbon. We need to select the freeze panes command on the view tab.

    Freeze Cells in Excel Ex. 1.1

  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.

    Freeze Cells in Excel Ex. 1.2

  4. 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 in ExcelFreeze Panes In ExcelIn a worksheet, "freeze panes" fixes any row or column. It's usually used on headers so that users can see which columns contain certain kind of data. You can also fix rows that aren't the first ones.read more’ command is now changed to the ‘Unfreeze Panes’ command. By clicking on it, the frozen cells are unfrozen. This command unlocks all the rows & Columns to scroll through the worksheet.

    Freeze Cells in Excel Ex. 1.3

In this example, the date is provided in the columns instead of the rows.

lock Column Ex. 1
  • Step 1: We need to select the Columns, which we need to freeze excel cells by clicking on the alphabet of the column.
lock Column Ex. 1.1
  • 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.
Freeze Cells in Excel 1.2
  • 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.
lock Column Ex. 1.3

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 two other commands as well in the Freeze panes options, which are ‘Freeze Top Row’ & ‘Freeze First Column.’

Freeze Cells in Excel Ex. 1.4

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.

Example #2

Let us take an example of the same.

  • Step 1: The sheet below shows the timesheet of a company. The columns contain the headers as Day, Date, Regular Hours, Overtime Hours, Sick, Vacation & Total.
Freeze Cells in Excel Example 1
  • 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.
Locking Row Column Example 1-1
  • 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.
Example 1-2
  • Step 4: As we can see from the snapshot below, there are two grey lines denoting the locking of cells.
Locking Row Column Example 1-3

Use of Rows & Column Freezing in Excel Cell

If we use the Freezing Panes command to freeze the columns and rows of excel cells, they will 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.
Example 2

In this case, it becomes a necessity to freeze certain excel columns and rows cells for understanding the Attendance of 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.’
Locking Row Column Example 2-1
  • 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.
Example 2-2

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.

Locking Row Column Example 2-3

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 the freezing of rows and columns in excel.

Things to Remember

Recommended Articles

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 a downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>