Ask Your Question

How to know if a cell is referred in formulas of other cells? [closed]

asked 2014-03-09 14:39:17 +0200

fxam gravatar image

I want to delete some cells, but I want to make sure that these cells are not referenced in formulas of other cells. How do I do that?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 06:48:29.288284

1 Answer

Sort by » oldest newest most voted

answered 2014-03-09 16:21:44 +0200

m.a.riosv gravatar image

I think there is an option in Menu/Tools/Detective/Trace dependents [Shift+F5].

Also you can search for a reference to the cell with Menu/Edit/Find

edit flag offensive delete link more


Thanks! Trace Dependents is great, Edit->Find & Replace then search in Formulas works too.

fxam gravatar imagefxam ( 2014-03-10 00:38:03 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-09 14:39:17 +0200

Seen: 1,068 times

Last updated: Mar 09 '14