Customize FORMULAS Tab Toolbar in Excel 2013
On the ribbon in Excel 2013, there is a Formulas toolbar. In this example tutorial you can see that, this Formulas toolbar helps us to work with functions that Excel supports, defining the names of cells and ranges of data, tracking formulas, various calculations in Excel 2013.
It contains some basic commonly used commands in dealing with the Function Library, Formula Auditing, etc.
The commands in the Formulas Tab toolbar
This toolbar consists of several groups of commands that contain command again, possibly within the respective groups. I will try to show the commands that contain certain groups in the toolbar formulas.
Toolbar formulas contain the following groups of commands: Function Library, Defined Names, Formula Auditing, Calculation.
- Function Library group command contains the following commands to work in Excel 2013:
- Insert Function
- AutoSum
- Recently Used
- Financial
- Logical
- Text
- Date & Time
- Lookup & Reference
- Math & Trig
- More Function
- Defined Names group command contains the following commands to work in Excel 2013:
- Name Manager
- Define Name
- Define Name
- Apply Names
- Use in Formula
- Paste Names
- Create from Selection
- Formula Auditing group command contains the following commands to work in Excel 2013:
- Trace Precedents
- Trace Dependents
- Remove Arrows
- Remove Arrows
- Remove Precedents Arrows
- Remove Dependent Arrows
- Show Formulas
- Error Checking
- Error Checking
- Trace Error
- Circular References
- Evaluate Formula
- Watch Window
- Calculation group command contains the following commands to work in Excel 2013:
- Calculation Options
- Calculate Now
- Calculate Sheet