Menu
I am trying to reverse engineer an ancient program written using VBA in excel and formulas in cells. There are many cells with values scattered across everywhere. Is there a fast way to check if a cell (value) is being used in another cell's forumla; or if the cell is just sitting there doing nothing so that I can delete/igonore it safely? Thanks in advance.
I used the Ctrl+F find tool and it seems like it does work, but I just want to be sure if there is another better way.
545
Go to Formulas tab > Formulas Auditing > Trace Dependents. Click on the Trace Dependents button to see the cells that are affected by the active cell. It will show a blue arrow that links the active cell and the other cells related to the selected cell.
On the Home tab, in the Editing group, click Find & Select, and then click Find. In the Find what box, enter the text—or numbers—that you need to find. Or, choose a recent search from the Find what drop-down box. Note: You can use wildcard characters in your search criteria.
Syntax. cell - The cell to check for a formula. ISFORMULA returns TRUE if cell is a cell that contains a formula. If cell contains a range of cells then TRUE will be returned if the first cell in the range contains a formula.
On Excel 2010 try this:
169
Have you tried Tools > Formula Auditing?
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
