Formulas Tab :
Defined Names Group :
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
Steps :
Defined Names Group :
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
Steps :
- Type the Text
- Select the Cell
- Click on Formula Tab
- Then click on Define name
- Give the name to that data
Formula Auditing Group :
Formula auditing in Excel allows you to display the relationship between formulas and cells.
Trace Precedents : Show arrow that indicate what cells affect the value of the currently selected cell.
Trace Dependent : Show arrows that indicate what cell are affected by the value of the currently selected cell.
Remove Arrows : Remove the arrows drawn by trace Precedents or Trace Dependents.
Show Formulas : Display the formula in each cell instead of resulting value.
Evaluate Formula :Launch the Evaluate Formula dialog box to debug a formula by evaluating each part of the formula individually.
Follow @Sarvavasi.com