is there a way to show what each cell links to?

L

liz

i have created a massive document containing 15 spreadsheets, some cells are
linked on multiple sheets and i wanted to know if there was a way to click on
the cell and it would show what other cells have it linked in their formula
 
M

Mike H

Hi,

Select the cell then

Tools|Formula Auditing
Click on trace precedents or Dependents

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Linking data in MS Word into Excel 5
Crating User Form to Add Names 1
Excel does not accept text format! 0
Converting URLs in comments to Markdown-formatted links 2
Embed the same Excel multiple times 0
External cell reference between two excel worksheets both in One Drive 0

Top