Thank chile.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: 03 August 2012 9:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Trace Precedents and Trace Error

 

Rajan 

 


These tool in Excel allows us to Trace Precedents in a formula, Trace
Dependents , Show formulas, Error checking and Evaluating formula in Excel.

Imágenes integradas 1

 

detail

 

·  Trace Precedents: When you click this button, Excel draws arrows to the
cells (the so-called direct precedents) that are referred to in the formula
inside the selected cell. When you click this button again, Excel adds
"tracer" arrows that show the cells (the so-called indirect precedents) that
are referred to in the formulas in the direct precedents.

·  Trace Dependents: When you click this button, Excel draws arrows from the
selected cell to the cells (the so-called direct dependents) that use, or
depend on, the results of the formula in the selected cell. When you click
this button again, Excel adds tracer arrows identifying the cells (the
so-called indirect dependents) that refer to formulas found in the direct
dependents.

·  Remove Arrows: Clicking this button (or the Remove Arrows option on its
drop-down menu) removes all the arrows drawn, no matter what button or
command you used to put them there. 

·  Show Formulas: To display all formulas in their cells in the worksheet
instead of their calculated values (just like pressing Ctrl+`).

• Error Checking: When you click this button or the Error Checking option on
its drop-down menu, Excel displays the Error Checking dialog box, which
describes the nature of the error in the current cell, gives you help on it,
and enables you to trace its precedents. Click the Trace Error option on
this button's drop-down menu to attempt to locate the cell that contains the
original formula that has an error. Click the Circular References option on
this button's drop-down menu to display a menu with a list of all the cell
addresses containing circular references in the active worksheet.

 

·  Evaluate Formula: Clicking this button opens the Evaluate Formula dialog
box, where you can have Excel evaluate each part of the formula in the
current cell. The Evaluate Formula feature can be quite useful in formulas
that nest many functions within them.

 

Chilexcel

2012/8/3 Rajan_Verma <rajanverma1...@gmail.com>

 

Hi Group,

 

Is there any difference in Trace Precedents and Trace Error in Excel??

 

I don’t need any link to see because  I have already Google it.

 

Regards

Rajan verma

+91 7838100659 <tel:%2B91%207838100659>  [IM-Gtalk]

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> 
 
 




-- 

Visita ; http://sites.google.com/site/chilexcel/Home

Visita ; http://www.youtube.com/user/timextag41

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 
 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


<<image001.jpg>>

Reply via email to