ShortieCuts - App for Tracing Formulas in Google Sheets

ShortieCuts: The Ultimate Tool for Tracing Formulas in Google Sheets
‍

How to Trace Formulas in Google Sheets

If you’ve ever found yourself wondering “how did this value come to be?” while working in Google Sheets, then this post is for you! We’re going to look at how you can trace your formulas and cell references in a sheet. This will enable you to understand exactly where certain values are coming from, giving you greater control over your data analysis and making it easier for you to make changes quickly.

‍

When to Use Trace Formulas

Tracing formulas is the process of seeing which cells are used by a particular formula in your spreadsheet. This allows you to easily identify where things may have gone wrong with your calculations or optimize them for better performance. It's also useful when working with complex formulae that involve many different cells, as it helps you keep track of everything and reduces the risk of error.

‍

How Tracing Formulas Works in Google Sheets

Google Sheets has no built-in Trace Precedents or Trace Dependents command, and no formula auditing toolbar like Excel's. Out of the box, the closest you can get is clicking into a formula to see its references highlighted, or using Find and replace with "Also search within formulas" to hunt for cells that mention a reference. That's the gap ShortieCuts fills. For example, say cell A5 contains the formula =A2+A3*A4. Its precedents are A2, A3 and A4, the cells it reads from. Its dependents are any cells whose formulas refer to A5. With ShortieCuts, select A5 and press Ctrl + ] to jump to its dependents, just like Excel.

Press Ctrl + [ instead to trace precedents: ShortieCuts selects the cells the formula refers to (in our example above, A2, A3 and A4), even when they sit on another tab. Press F5 to open the Traces list and jump back to where you started. Show Formulas (Ctrl + ` in Google Sheets) is also useful when auditing, because it displays the formula in every cell.
‍

The Power of Tracing Formulas in Google Sheets

Tracing formulas can unlock powerful capabilities in Google Sheets. When you’re working on complex problems or large data sets, one small error can have catastrophic effects. That’s where tracing formulas come in.

Easily store, document, and modify your formulas in Google Sheets. Its powerful formula tracing feature allows users to better identify how their data is being used in calculations. A quick audit of your formulas can help you reduce errors and improve accuracy. The ability to examine the dependencies between cells in a spreadsheet provides an efficient way to understand the inner workings of complex documents. Not only is formula tracing helpful for detailed inspection of your data, but it also serves as a security measure since intricate computational relationships are exposed. Through this feature, you can easily detect and prevent any discrepancies that could lead to incorrect or dangerous results. With a formula tracing tool, you can confidently and securely draw insights from your data!

‍

Trace Formulas Examples and Use Cases

Trace formulas are powerful tools used by people who spend lots of time in spreadsheets manipulating data like finance professionals. They typically involve the calculation of the anticipated value of a security at various points in time based on known figures, providing a comprehensive picture of projected values for any given time frame. For example, a stock broker may use a trace formula to figure out what his portfolio will be worth in twelve months based on current investments and market conditions.

Other use cases include risk analysis - where one is able to gauge expected return versus investment risk - and asset valuation which can allow an investor to analyze relative attractiveness when comparing multiple assets. Trace formulas provide multiple benefits when it comes to financial planning, but only if utilized properly by an experienced professional.

 
Tracing formulas is an essential part of data analysis when using Google Sheets. By using Trace Precedents and Trace Dependents, you can quickly trace your formulas back to their source and gain greater control over your data analysis. As such, understanding how to use these tools will make your work with spreadsheets much more efficient and effective!
‍

A Helpful Tool for Spreadsheet Professionals

If you use Google Sheets on a regular basis, you know how important it is to be able to trace formulas and understand how they work. Unfortunately, Google Sheets doesn’t offer many tools for tracing formulas, which can make it difficult to troubleshoot errors or understand how a sheet is put together. That’s where ShortieCuts comes in.
‍

What is ShortieCuts?

ShortieCuts is a Chrome extension that brings many of the familiar features of Excel to Google Sheets. One of the most useful features is the ability to trace formulas, which allows you to see which cells are dependent on a particular formula and which cells a formula is dependent on. It also supports Excel Alt key shortcuts in Google Sheets.
‍

Why use ShortieCuts for tracing formulas?

There are a few key reasons why you might want to use ShortieCuts for tracing formulas in Google Sheets:

Troubleshooting: If you’re working with a complex sheet and you’re not sure why a particular formula isn’t working as expected, being able to trace the formula can help you identify the problem. Formulas that check for text are explained in the formula for if a cell contains text.

Understanding: Even if you’re not having any issues with your formulas, being able to trace them can help you understand how a sheet is put together and how different formulas are connected.

Improved productivity: By being able to quickly and easily trace formulas, you can save time and work more efficiently.
‍

How to use ShortieCuts for tracing formulas:

Using ShortieCuts for tracing formulas is easy: just install the extension from the Chrome Web Store and open your Google Sheet. Then, select a cell and press Ctrl + [ to trace its precedents or Ctrl + ] to trace its dependents, the same keys as Excel. Press F5 to open the Traces list and return to the original cell after tracing.
‍

Conclusion:

Tracing formulas is an essential tool for anyone who uses Google Sheets regularly, and ShortieCuts makes it easy to do so. By installing the extension, you can quickly and easily trace dependents and precedents, helping you troubleshoot errors and understand how your sheets are put together. Give it a try and see how it can improve your productivity and understanding of your Google Sheets.

Updated October 2026

Trace Precedents and Dependents in Google Sheets: Step by Step

Precedents vs Dependents

The two directions are easy to mix up, so it helps to anchor them to one cell. Say C10 holds gross profit with the formula =C8-C9, and C12 holds operating profit with =C10-C11.

• Precedents are the cells a formula reads. C8 and C9 are the precedents of C10. Tracing precedents answers: where does this number come from?
• Dependents are the cells whose formulas read a given cell. C12 is a dependent of C10. Tracing dependents answers: what changes if I change or delete this cell?

Google Sheets Has No Built-In Trace

To be plain about it: Google Sheets has no Trace Precedents or Trace Dependents command, no formula auditing toolbar and no tracer arrows. There is nothing in the menus to turn on. Excel users who reach for Ctrl + [ or Formulas > Trace Precedents will find no equivalent. You either use the manual workarounds below or add the commands with an extension.

How To Trace in Google Sheets With ShortieCuts

ShortieCuts puts tracing on the same keys Excel uses.

1. Trace precedents. Select a formula cell and press Ctrl + [. ShortieCuts selects the cells the formula refers to and jumps you to them, including references on other tabs.
2. Trace dependents. Select any cell and press Ctrl + ]. ShortieCuts finds the cells whose formulas refer to it. It searches the current sheet first and, if it finds none there, searches all sheets.
3. Go back. Press F5 to open the Traces list, which records the cells you traced from, and pick one to jump back. It plays the same role as pressing F5 and Go To after a trace in Excel.
4. Keep going. Trace again from the cell you landed on to walk further up or down the chain one level at a time.

On a Mac, use the Control key for the trace shortcuts. Trace is a Pro feature and is included in the 14-day free trial, with no credit card required; plans are on the pricing page.

Native Workarounds Without an Extension

If you are on a machine without ShortieCuts, two built-in features get you part of the way.

Precedents: click into the formula. Select the cell and press F2 or double-click it. Sheets outlines each referenced range on the grid in a color that matches the reference in the formula text. This works well for same-tab references. References to other tabs are not outlined, so you have to read the tab name in the formula and go there yourself.

Dependents: search inside formulas.

1. Note the address of the cell you are checking, for example C10.
2. Press Ctrl + H (Cmd + Shift + H on a Mac) to open Find and replace.
3. Type C10 in the Find box.
4. Set Search to All sheets if the model spans tabs.
5. Tick Also search within formulas.
6. Click Find repeatedly to step through every formula that contains the text.

This is a text search, so read the results with care. It also matches C100 and C101. It misses formulas that include the cell inside a range, such as =SUM(C5:C20), references through a named range, and references built with INDIRECT or OFFSET. Treat it as a first pass, not proof that nothing else depends on the cell.

See all formulas at once. View > Show > Formulas switches the grid to display formulas instead of results, which is useful for scanning a block for hardcodes. With ShortieCuts the Excel key Alt + M + H does the same.

Tips for Auditing a Model in Sheets

• Start from the output and trace backwards. Begin at the number someone will quote, such as the IRR or the closing cash balance, and press Ctrl + [ one level at a time until you reach inputs.
• Trace dependents before deleting anything. Pressing Ctrl + ] on a row you plan to delete shows what would break. Deleting a referenced cell is a common source of #REF! errors; see fixing #REF! errors in Google Sheets.
• Look for hardcodes in formulas. A formula such as =C8*1.05 has a precedent you cannot trace: the 1.05. Move it to an inputs cell so it shows up in a trace.
• Check cross-tab links deliberately. Most model errors live in the links between tabs. Because ShortieCuts follows precedents onto other tabs and searches all sheets for dependents, trace each link between your inputs, model and output tabs at least once.
• An empty dependents trace is a signal. An input with no dependents is either unused or wired wrongly. Either way, it is worth a look.

For Excel's own version of these steps, see how to trace precedents in Excel.

Keyboard Shortcuts at a Glance

Action	Windows	Mac	Available In
Trace precedents	Ctrl + [	Control + [	ShortieCuts Pro
Trace dependents	Ctrl + ]	Control + ]	ShortieCuts Pro
Traces list (jump back)	F5	F5	ShortieCuts Pro
Trace precedents / dependents from the Formulas key tips	Alt + M + P / Alt + M + D	Option + M + P / Option + M + D	ShortieCuts Pro, available (version 1.2.9 and later)
Show formulas	Alt + M + H	Option + M + H	ShortieCuts
Find and replace (search within formulas)	Ctrl + H	Cmd + Shift + H	Google Sheets

The full list of Excel shortcuts ShortieCuts supports is on the shortcuts index.

Frequently Asked Questions

Does Google Sheets have Trace Precedents or Trace Dependents?

No. Google Sheets has no built-in trace command or tracer arrows. ShortieCuts adds Trace Precedents on Ctrl + [ and Trace Dependents on Ctrl + ], the same keys as Excel.

How do I find dependents in Google Sheets without an extension?

Open Find and replace with Ctrl + H, type the cell address, tick Also search within formulas and step through the matches. It is a text search, so it can match similar addresses and will miss references inside ranges such as SUM(C5:C20).

Can ShortieCuts trace references on other tabs?

Yes. Trace Precedents follows references onto other tabs, and Trace Dependents searches all sheets when it finds no dependents on the current one.

How do I get back to the cell I traced from?

Press F5 to open the Traces list and pick the cell you started from, similar to using Go To after a trace in Excel.

Do Alt + M + P and Alt + M + D trace precedents and dependents in ShortieCuts?

Yes, available now from ShortieCuts version 1.2.9 onward (the current version is 1.3.0). Alt + M + P and Alt + M + D run the same Trace Precedents and Trace Dependents as Ctrl + [ and Ctrl + ], matching Excel's Formulas tab key tips. Ctrl + [ and Ctrl + ] also work.