Excel should find all places a particular cell is referenced

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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 Shortcut to go to the page/document referenced within a cell in excel 0
Excel VBA 1
Nest a referenced formula in excel 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Absolute Reference is changing 2
Integration in Excel 0
Can trendline equations be automatically entered into cells? 1
Is there a function to solve for an unknown in an equation? 9

Back
Top