error in excel help. how to select a cell after clicking the Select All button?

  • Thread starter Dmitriy Kopnichev
  • Start date
D

Dmitriy Kopnichev

Hello
"To see all the relationships on a worksheet, in an empty cell type = (equal
sign), and then click the Select All button. Select the cell, and press
Trace Precedents twice." is written in Excel 2002 help. It's not possible
to "Select the cell" following the procedure. Or How to "select the cell" in
the procedure?
 
D

Debra Dalgleish

Type an =, then click the Select All button, then press the Enter key.
You should see a warning about a circular reference.
Click Cancel, to go ahead with the formula.
Select the cell with the formula
Click the Trace Precedents button twice, to see the relationships.
 

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

AppleScript - How do I select a text ? 1
Macro to select all the filled cells in a worksheet? 43
Inserting a Copied Row inside a table 6
"Compile error in table level validation expression " after format 0
unable to add row to Excel 2007 TABLE 3
Selecting cells in Excel 3
Code to select rows by a null cell in a set column 3
loop until empty row and column problem (format cells until the lastrow and column in a report) 4

Top