Step 1:Identifythe row above which you want to freeze the rows. For instance, if you want to freeze the top two rows, select the third row. Step 2:Navigateto the "View" tab and access the "Freeze Panes" drop-down menu. From the available options,selectthe first entry named "Freeze P...
In simple terms, when you freeze a cell, that cell will continue to display on the window even when you scroll up and down, as well as left and right. Freezing cells does not lock the cell data (seeour story on protecting data by locking it); it just keeps the cells in view. That...
While working with larger spreadsheets, you will need to know how to freeze cells in Excel. You do not need to scroll up and down repeatedly, instead just freeze the cells to compare the header information with the rest of the rows quickly. So, here, we explain you the technique to free...
To unlock the worksheet, go to Review –> Changes –> Protect Sheet. If you had used a password to lock the worksheet, it will ask you to enter that password to unlock it. Also read:Freeze Columns in Excel Lock Some Specific Cells in Excel Sometimes, you may want to lock some specifi...
Freeze Top Row:ALT + W + F + RFreeze First Column:ALT + W + F + CFreeze Panes:ALT + W + F + F To explore more Excel shortcuts, you can check out our other article on200+ Excel Keyboard Shortcut. Using Freeze Panes Excel has a default Freeze Panes menu in the View Tab. If...
1. Select the row below the last row to be locked. 2. Go to the View tab > Freezing Panes. 3. Click the Freeze Panes option. Read more here.
The tutorial shows how to freeze cells in Excel to keep them visible while you navigate to another area of the worksheet. Below you will find the detailed steps on how to lock a row or multiple rows, freeze one or more columns, or freeze column and row at once. ...
Method 1 – Shortcut to Freeze Both Rows and Columns STEPS: Select the cell row or column (i.e., row9). Click on row9, or on any cell in row 9, and pressShift + Spacebar,to select the whole row. PressAlt + W + F,at the same time. TheFreeze Panesoption will open. ...
Method 2: Freezing Top Two Rows Using Shortcut key You can also use ashortcutkey to freeze the top two rows in a sheet: First, select the cellA3since you’re freezing the rows above this cell. Then, pressALT + Wto enter the View tab. After that, Excel will show further keyboard pr...
Step 2:Go to VIEW tab > Freeze Panes > Freeze Top Row. We have a shortcut key as well. Press ALT + W + F + R. ADVERTISEMENT VBA Macros Course Bundle - Specialization | 18 Course Series | 13 Mock TestsMost Popular Learning Paths in Excel ...