Using Absolute Cell References
When you need an equation to reliably allude to a specific cell, regardless of whether you duplicate or move the recipe somewhere else on the worksheet, you have to utilize a flat out cell reference. A flat out cell reference is a cell address that contains a dollar sign ($) in the line or segment facilitate, or both. When you enter a cell reference in an equation, Excel expect it is a relative reference unless you change it to a flat out reference. In the event that you need some portion of a recipe to remain a relative reference, expel the dollar sign that shows up before the section letter or column number.
Make an Absolute Reference
Snap a cell where you need to enter an equation.
Sort = (an equivalent sign) to start the equation.
Select a cell, and after that sort a number juggling administrator (+, - , *, or/).
Select another cell, and after that press the F4 key to make that cell reference outright.
You can keep on pressing F4 to have Excel go through the diverse reference sorts.
On the off chance that vital, keep entering the recipe.
Tap the Enter catch on the recipe bar, or press Enter.
For More Videos about Excel VISIT
