I'm working with a large spreadsheet designed by someone else. Is there any way of detecting which other cells are affected by a particular cell.
For example if cell B2 in Sheet 1 is used as a factor in formulae in cells QS45, SD20 and XA440 on Sheet 40, is the any way that I can tell that at B2? At the moment I've no idea, if I delete something, if that might affect this or other sheets.
Bookmarks