Sheet Pro is a Chrome Extension that allows users to trace precedents more easily in Google Sheets.
By invoking the Sheet Pro extension in Google Sheets when you are editing / viewing a formula, the Sheet Pro tracer allows you to walk through each dependent cell in a formula step by step.
Sheet Pro is FREE for early adopters.
https://www.youtube.com/watch?v=h2zWfwk0BnY&embeds_referring_euri=https%3A%2F%2Fchromewebstore.google.com%2F&source_ve_path=MjM4NTE
Why Sheet Pro?
- Sheet Pro makes it quicker and easier to audit Google Sheets
- Sheet Pro makes it faster to build Google Sheets
- Sheet Pro can help you avoid making formula errors
- Sheet Pro also works with excel workbooks in Google Sheets
Install the extension here:
Sheet Pro - Chrome Web Store
How to use Sheet Pro
To get going:
- Install the extension here
- Open a Google Sheet and navigate to a cell with a formula within it
- Press “ctrl + shift + s” for windows or “command + shift + s” for mac users. This begins/invokes the Sheet Pro tracer, which appears as a pop-up.
- Then, use the left and right arrow keys to move between the traced cell and its input cells