Hello everyone,
I have had one big question regarding Excel for years, and I just signed up here to finally get to ask knowledgeable people about it.
When you write a formula in a cell, Excel displays the other cells used to write the formula by means of different colors.
But is it possible to do the opposite? When selecting one cell (say A1), is there a way for Excel to display all the other cells across the sheet that contain formulas written with A1?
That way if you're about to delete a cell somewhere in your spreadsheet, you can check first that doing it won't affect other cells somewhere else.
Thank you in advance for your help, have a nice one.
Pierre
Bookmarks