Freezing a cell of a spreadsheet created in Excel, which is included in the Microsoft Office suite, means creating an absolute reference to the selected cell. This action is standard for Excel and is performed using standard tools.
Instructions
Step 1
Call the main system menu by clicking the "Start" button and go to the "All Programs" item. Expand the Microsoft Office link and start Excel. Open the application workbook to be edited.
Step 2
An absolute reference in table formulas is used to indicate a fixed cell address. Absolute references remain unchanged during move or copy operations. By default, when you create a new formula, a relative reference is used, which can change.
Step 3
Highlight the link to be anchored in the formula bar and press the F4 function key. This action will cause a dollar sign ($) to appear in front of the selected link. Both the line number and the letter of the column will be fixed in the address of this link.
Step 4
Press the F4 function key again to fix only the line number in the address of the selected cell. This action will cause the row to remain unchanged while dragging the formulas and the column to move.
Step 5
The next press of the F4 function key will change the cell address. Now the column will be fixed in it, and the row will move when moving or copying the selected cell.
Step 6
Another way to create absolute cell references in Excel is to manually do the link pinning operation. To do this, when entering a formula, you must print a dollar sign in front of the column letter and repeat the same action before the line number. This action will cause both of these parameters of the address of the selected cell to be fixed and will not change when moving or copying this cell.
Step 7
Save your changes and exit Excel.
