I want to trace precedents in Google Sheets

I want to trace precedents in Google Sheets.
It is not possible to do that in Google Sheets.

The closest way is to open the file with Excel or LibreOffice Calc. But there are compatibility problems with special formulas and macros.


(Update: Please see the comments for this post)

Comments

  1. Mir Arif Billah16 April 2018 at 10:02

    I think google does not have this function.

    ReplyDelete
  2. Anonymous5 December 2018 at 23:58

    see https://webapps.stackexchange.com/questions/77940/how-can-i-trace-precedents-in-google-sheet if you are not afraid at using small script.

    ReplyDelete
  3. Unknown15 January 2019 at 12:27

    There is an addon for this in google sheets, it is called "Find precedents and dependents". You can install addons using the menu in google sheets. You use it from the menu item (it is under "add-ons" once installed).

    ReplyDelete
  4. Unknown24 January 2019 at 17:53

    Thank you for the update.

    ReplyDelete
  5. Anonymous12 October 2023 at 23:51

    I found this add on that has both trace precedents and trace dependents https://chrome.google.com/webstore/detail/google-sheets-excel-short/bfncmfmdadhimlnpeecppaimgmeeppan

    Looks like they also have Excel formatting shortcuts, like the alt shortcuts you might be use to in Excel.

    ReplyDelete

Post a Comment

Popular posts from this blog

LibreOffice Calc Users have Powerful Precedent Tracing Tools

LibreOffice Calc has a Detective menu to trace precedents and dependents. Similar to Excel's formula auditing tools, the tracings are limited to one cell at a time, and each click goes one level further. This new book,  Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc), improves the detective tracing ability with LibreOffice Basic programming. Calc users can now trace precedents and dependents over many cells, or many levels at once. There are more functions described in the book. This unique spreadsheet book shows you how you can quickly and easily gain an overview of your spreadsheet model, with just a few clicks. The automatically generated overview, with the specialized software (VisualCheck, tested with LibreOffice 5.3) that comes with the book, allows easy understanding and error detection, as illustrated in the book. This book is meant for all types of spreadsheet users. It is meant for both novice and exp...
Read more