To avoid the aforementioned shortcomings, you should enter the cell references of the cells containing the values, rather than typing the actual values, as shown in the following screenshot:
The formula bar in the preceding screenshot shows that we entered F5*I5.
In this way, it is clear where the input is coming from. All the cells that have formulas that refer to those cells will be automatically updated.
Another advantage of referencing is that, by default, Excel registers the position of the cell references relative to the active cell. So, in the preceding example, F5 is registered as four cells to the left, and