In case you change the value in cell A2, the resulting data would automatically update. Note: Using the formula method has an advantage – which is that the result is dynamic. You will now get a whole column of cells containing the difference between cell A2 and cells B2:B11. Drag down the fill handle on the lower-right corner of cell C2 to copy the formula for all cells (C2:C11).Press the Return/Enter key on your keyboard.
You can also manually add these dollar signs if you want. Notice that the cell location A2 changes to $A$2. The easiest way to do this is by using a simple subtraction formula. Let us say you have a dataset as given below (cells B2:B11) and you want to subtract each of these values from the value in cell A2. Subtract Multiple Cells from a Cell using a Formula
Difference between Absolute and Relative Cell References in Excel.Subtract Multiple Cells from a Cell using a Formula.
