| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell References
eg: If iam using "Sheet1A1" as my reference in sheet2 & some other sheets in
other files, can I know which cells are using "Sheet1A1" as its reference by clicking on cell "A1" in "Sheet1" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell References
Not simply by 'clicking' on it. However, if you select that cell and then
use the Trace Dependents option on the Tools-Formula Auditing menu, you'll get a window that shows the cells that reference it. "C.M." wrote: eg: If iam using "Sheet1A1" as my reference in sheet2 & some other sheets in other files, can I know which cells are using "Sheet1A1" as its reference by clicking on cell "A1" in "Sheet1" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Displaying multiple cell references in 1 cell | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
![C.M.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
