In complex worksheets, where the value in one cell impacts several other
cells and formulas, it’s helpful to understand the relationship between
those cells—especially if it’s a spreadsheet you didn’t personally
create. This tip will help you troubleshoot and understand what’s going on.
Select a cell in your worksheet and then press Ctrl-Shift-] (that’s
Control-Shift-Right Bracket) and all of the cells that are dependent on the
selected cell will be highlighted.