![]() ![]() We need to select the formula cell and then click on the ‘Trace Precedents’ command. Then you can see an arrow as shown below. We can see that precedent cells are highlighted with blue dots. ![]() To remove these arrows, we can use the ‘Remove Arrows’ command in the ‘Formula Auditing’ group under the ‘Formulas’ tab. This command is used to trace the cell, which is dependent on the selected cell. Suppose we have four amounts that we can invest in. We want to know how much interest we can earn if we invest. We can see that in the above image, we have applied a formula for calculating interest with Amount 1 and specified interest percentage and duration in the year. We will copy the formula and paste it in the adjacent cells for amount 2, amount 3, and amount 4. ![]() It can be noticed that we have used an absolute cell reference Absolute Cell Reference Absolute reference in excel is a type of cell reference in which the cells being referred to do not change, as they did in relative reference. By pressing f4, we can create a formula for absolute referencing. read more for G2 and I2 cells as we do not want to get changed these references while copying and pasting. Now, if we want to check if which cells are dependent on the G2 cell, then we will use the ‘Trace Dependents’ command available in the ‘Formula Auditing’ group under the ‘Formulas’ tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |