MS excel pro help pls

N

numbers

Master Member
Joined
Oct 24, 2006
Messages
2,864
Reaction score
771
i got a super complex spreadsheet with many sheets and formulas linking everywhere.

Is there anyway to tell if a certain cell is being used by a formula in another sheet before i delete the cell? I am trying to clean up and delete unused cells....
 
P

peterchan75

Supremacy Member
Joined
Apr 26, 2003
Messages
6,719
Reaction score
529
Under formulas, highlight the cell that you are deleting and click Trace Dependents / Trace Precendents.
 
You must log in or register to reply here.
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ Forums. Forum members and moderators are responsible for their own posts. Please refer to our Community Guidelines and Standards and Terms and Conditions for more information.
Top