Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel should find all places a particular cell is referenced
In Office 2003, it would be nice if by highlighting a cell there was a
function that would allow a user to see all other places in the worksheet where the cell is referenced. It could be similar to the way clicking on an equation puts colored boxes around cells used in the equation. |
#2
|
|||
|
|||
Jules,
Select the cell, then press Ctrl-], (Select dependents) and Excel will select all cells that reference the selected cell on the current sheet. HTH, Bernie MS Excel MVP "julesme1" wrote in message ... In Office 2003, it would be nice if by highlighting a cell there was a function that would allow a user to see all other places in the worksheet where the cell is referenced. It could be similar to the way clicking on an equation puts colored boxes around cells used in the equation. |
#3
|
|||
|
|||
Aaron Blood has a free Excel add-in on his website that
may interest you: http://www.xl-logic.com/pages/explode.html Look for "explode.zip". HTH Jason Atlanta, GA -----Original Message----- In Office 2003, it would be nice if by highlighting a cell there was a function that would allow a user to see all other places in the worksheet where the cell is referenced. It could be similar to the way clicking on an equation puts colored boxes around cells used in the equation. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
excel locks up after selecting a cell | Excel Discussion (Misc queries) | |||
How can I find strings of wildcards in Excel? | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) |