How to fix a cell in Excel
By
SpreadCheaters
Page last updated:
19/11/2022 |
Next review date:
19/11/2024
You can watch a video tutorial here.
Fixing/Locking in a cell is one of the most important skills to learn, especially creating a formula. This can be used as a reference point.
Step 1 – Create a formula
– In this example, Sales has been computed as the sum of the small and large bags, and the product of the average price and profit margin.
Step 2 – In the formula bar, click on the cell you want to lock in and press F4.
– Pressing in F4 will automatically lock in the cells. When you start dragging the formula down, cells B1 and B2 will be fixed.
