Today’s topic is tracing precedents.
Sometimes spreadsheets can get really big and formulas become very complicated. In those situations it can be hard to tell exactly which cell a formula is referring to. Excel gives you a few ways to deal with this situation.
One way is to use the “trace precedents” option. If you use the trace precedents feature, Excel will insert arrows into the spreadsheet to show you which cells are being used in the function. Here is a picture of a very basic example:
To use this feature, click the “Formulas” menu on the ribbon and then from the “Formula Auditing” group click on “Trace Precedents.”(PC Keyboard shortcut: Alt → M → P)
Here is an example if some of your data is on another worksheet:
To do this, click the “Formulas” menu and then from the “Formula Auditing” group click on “Remove Arrows” (PC Keyboard shortcut: Alt → M → A → A).