Precedents

Hi Joseph

Thanks for getting in touch. A simple way to do this is to double-click a cell. This will start editing the cell, and will colour the border of a cell that is involved with this formula.

A more sophisticated way to see this is to go to the Formulas tab, click on the cell that contains your formula and choose Trace Precedents. This will draw arrows directing you to the source data of the formula.

If the source goes to a different worksheet or workbook, a dashed line will appear - double-click this line to follow the trail.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector