Freezing is the process of keeping rows and/or columns visible on screen at all times even when we scroll through a large dataset. When we apply freeze panes in excel, such as a row of column headings, the column headings remain visible as we scroll down the worksheet or change magnification.
So with the help of freeze panes in Excel, we can lock certain rows and columns at their place while we scroll throughout the worksheet. This is mostly required when we write a heading or a descriptive text in the first row or column and want it to stay in view while we fill up data against it.
(01) EXCEL FREEZE PANES OPTIONS
| Option | Description |
| Freeze panes | Keep both rows and columns above and to the left of the active cell visible as we scroll through a worksheet. |
| Freeze top row | Keeps only the top row visible as we scroll through a worksheet. |
| Freeze First Column | Keeps only the first column visible as we scroll through a worksheet. |
(02) HOW TO FREEZE CELLS IN EXCEL?
or, HOW TO FREEZE COLUMNS AND ROWS IN EXCEL?
To freeze one or more rows and columns, use the Freeze Panes option. Before selecting this option, select an active cell one row below and one column to the right of the rows and columns we want to freeze.➢ Method 1 Apply Freeze Panes Shortcut:
After selecting the active cell, apply the Excel shortcut Alt+W+F+F (sequentially press Alt, W, F, F).➢ Method 2 Apply Freeze Panes Using the Ribbon:
After selecting the active cell, Go to the View tab ➪ Click Freeze Panes drop-down ➪Select Freeze Panes. Thus, Excel displays a horizontal line below the last frozen row (row 2) and a vertical line to the right of the last frozen column (column B). Unfrozen rows (starting from row 3) and unfrozen columns (starting from C) are no longer visible when we scroll down and to the right, respectively. The frozen rows and columns are separated by dark lines. The frozen panes remain visible no matter how far we scroll away from the. If scrolled downwards, all the columns will scroll together, but the top row (containing the subject heading) will stay visible throughout. Likewise, when scrolled to the right, all the rows will scroll together, but the frozen column (the one containing the Bonus Date) will remain visible throughout.(03) HOW TO FREEZE COLUMNS IN EXCEL?
➢ Method 1 Apply Freeze Panes Shortcut:
We can only freeze any column by selecting the very next adjacent column with Ctrl+Spacebar and then press Alt+W+F+F (sequentially press Alt, W, F, F). In the given example, we want to freeze column B. Thus, we select the very next adjacent column C with Ctrl+Spacebar ➪ then press Alt+W+F+F (press sequentially Alt, W, F, F).➢ Method 2 Apply Freeze Panes Using the Ribbon:
We can select the column by clicking on the column address C at the top ➪ Then go to the View tab ➪ Click Freeze Panes drop-down ➪Select Freeze Panes. Note: If we have no specific choice to freeze panes in a specific column, then we apply Freeze First Column which will freeze the first column by default.(04) HOW TO FREEZE A ROW IN EXCEL?
➢ Method 1 Apply Freeze Panes Shortcut:
We can only freeze any row by selecting the very next adjacent row with Shift+Spacebar and then press Alt+W+F+F (sequentially press Alt, W, F, F). In the given example, we want to freeze the 2ndrow with the subject heading. Thus, we select the very next adjacent row number 3 with Shift+Spacebar ➪ then press Alt+W+F+F (press sequentially Alt, W, F, F).➢ Method 2 Apply Freeze Panes Using the Ribbon:
We can select the row by clicking on row number 3 on the left side ➪ Then go to the View tab ➪ Click Freeze Panes drop-down ➪ Select Freeze Panes. Note: If we have no specific choice to freeze panes in a specific row, then we apply Freeze Top Row which will freeze the first row by default.(05) HOW TO UNFREEZE PANES IN EXCEL?
➢ Method 1 Using the Excel Shortcut:
Click any cell in the worksheet ➪ Then press Alt+W+F+F (sequentially press Alt, W, F, F).➢ Method 2 Using the Ribbon:
Click any cell in the worksheet ➪ Go to the View tab ➪ Click Freeze Panes drop-down or arrow ➪ Select Unfreeze Panes.Premium Courses on ed2go
Premium Courses on Coursera
Premium Courses on Udemy
30+ BEST ADVANCE EXCEL COURSES | By Coursera, Udemy |
36+ BEST ADVANCED EXCEL COURSE ONLINE | By ed2go |
80+ Excel Shortcuts with ALT Key || Best Hotkey of Keyboard Shortcuts
03 Useful Methods : Add Numbers With AutoSum Excel
04 Simple to Advanced Methods: How to Filter in Excel?
05 Best Ways: Create Password Protect Excel & Unprotect it
08 Best Examples: How to Use Excel Conditional Formatting?
04 BEST WAYS: HOW TO TRANSPOSE DATA IN EXCEL
Tutorial 01: How to Use Excel SUMIFS Function with Single & Multiple Criteria