How to Freeze (Lock in Place) a Cell in Excel
Select the row(s) or column(s) located just below or to the right of the row(s) or column(s) you want frozen., Click on the tab labeled “View” at the top of your Excel session. , Click on the small arrow next to “Freeze Panes” located in the Window...
Step-by-Step Guide
-
Step 1: Select the row(s) or column(s) located just below or to the right of the row(s) or column(s) you want frozen.
For example, if you want to freeze row 1, select row
2.
When freezing a row(s) and column(s) at the same time, click on the one cell located just below and to the right of the row(s) and column(s) you want frozen.
For example, if you want to freeze row 1 and column A, click on the cell located in B2. -
Step 2: Click on the tab labeled “View” at the top of your Excel session.
,, The row(s) and/or column(s) you have selected will now be frozen in place.Select “Freeze Panes” when freezing a row(s) and column(s) at the same time. -
Step 3: Click on the small arrow next to “Freeze Panes” located in the Window group.
-
Step 4: Click on “Freeze Top Row” or “Freeze First Column
-
Step 5: ” based on your selection.
Detailed Guide
For example, if you want to freeze row 1, select row
2.
When freezing a row(s) and column(s) at the same time, click on the one cell located just below and to the right of the row(s) and column(s) you want frozen.
For example, if you want to freeze row 1 and column A, click on the cell located in B2.
,, The row(s) and/or column(s) you have selected will now be frozen in place.Select “Freeze Panes” when freezing a row(s) and column(s) at the same time.
About the Author
Diane Ferguson
Brings years of experience writing about creative arts and related subjects.
Rate This Guide
How helpful was this guide? Click to rate: