Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Freezing cells in excel means 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 windows section click on freeze panes and click on freeze panes, this will freeze the selected cells.
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 –