I have just recently learned there is a great feature for this, which I really miss in LibreOffice, since I came to know it exists:

https://support.microsoft.com/en-us/excel/display-the-relati...

https://support.microsoft.com/en-US/Excel/see-links-between-...

These really helped me to review low-to-mid complexity sheets where inserted rows and incorrectly copied formulas messed up stuff.