| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to show what each cell links to?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a way to show what each cell links to?
Hi,
Select the cell then Tools|Formula Auditing Click on trace precedents or Dependents Mike "liz" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel links to worksheets show only formula | Excel Discussion (Misc queries) | |||
| #VALUE! show up on "non-updated" links to another sheet | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
| using links to show data | Excel Worksheet Functions | |||
Linear Mode
