FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.

Detailed explanation-2: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.

Detailed explanation-3: -To do this, you’ll need to change the cell reference to an absolute reference by adding dollar signs before the row and column (for example, $D$2). Although you can type the dollar signs manually, the F4 key on your keyboard allows you to add both dollar signs with a single keystroke.

Detailed explanation-4: -The F4 key is the easiest way to lock cell references. Simply select the cell or range of cells that you want to lock, then press the F4 key. Excel will automatically add the $ sign to the appropriate places in the cell reference. One advantage of using the F4 key is that it’s quick and easy.