Excel Development Trace Precedents

How to use Trace Precedents in Excel Spreadsheets

If you are not sure which cells a formula is using, click “Trace Precedents” on the Formulas Tab to view arrows leading from all cells used to the formula cell. “Trace Dependents” does the same thing in reverse and “Remove Arrows” removes the arrows used to show precedents and dependents.

Contact us for a free consultation

Either call us now on 020 3817 6945 or fill out the form below and one of our team will be in touch.

The contact form requires that you configure reCAPTCHA in the site configuration.

The contact form requires that you select an email template.