When you click on the formula in a cell it shows you what other cells are linked to it. Often when checking my work I have to do this all over my spreadsheet in order to make sure everything is right......

Is there any setting/option or excel addin that automatically highlights the cells that are used in your formula or automatically traces precedents without having to click on anything other than selecting the cell?