# How To Lock A Cell In Excel Formula \$

When it comes to working with Excel, one of the things I often need to do is lock a cell in a formula. This can be a powerful tool for ensuring that specific cells remain constant, even when the formula is copied or filled into other cells. Let’s dive into the details of how to accomplish this!

## Understanding Cell Referencing

In Excel formulas, cell references can be of three types: relative, absolute, and mixed. A relative reference adjusts when the formula is copied to another cell, an absolute reference stays constant, and a mixed reference contains both relative and absolute components. Understanding these references is crucial to effectively locking cells in formulas.

## Using Absolute Cell Reference

When I want to lock a cell in a formula, I use the absolute cell reference. To do this, I place a `\$` symbol before the column letter and row number of the cell that I want to lock. For example, if I want to lock cell A1, I would use `\$A\$1` in my formula. This ensures that when the formula is copied to other cells, the reference to cell A1 remains absolute.

## Applying Absolute Reference in Formulas

Let’s say I have a simple formula `=A1*\$B\$1` in cell C1. When I copy this formula to cell C2, the cell reference A1 will change based on the new position, but the reference to B1 will remain locked due to the `\$` symbol. This is incredibly helpful when working with fixed values or constant factors in my calculations.