Use Cell References In Formula. A relative cell reference in a formula is based on the relative position of a referenced cell and a cell containing a formula. When you create a simple formula or a formula by that uses a function you can refer to data in worksheet cells by including cell references in the formula arguments.
Then click Formulas Trace Dependents. You could write a formula of INDIRECTA2 Note that the argument inside our function is the text string A2 and not a. Select the cell which you want to find out whether it is referenced or not by any formulas.
It can precede the column reference the row reference or both.
Then click Formulas Trace Dependents. Say that you want to fetch the value from A2 but you want to make sure that your formula stays on A2 regardless of new rows being insertedremoved. Cell references are used in excel functions formulas charts and various other excel commands. The other two formats are used much less frequently.