Excel tutorials

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.

Visual view of the toolbar or Formulas tab in Excel 2013

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.

  1. Function Library group command contains the following commands to work in Excel 2013:
    1. Insert Function
    2. AutoSum
    3. Recently Used
    4. Financial
    5. Logical
    6. Text
    7. Date & Time
    8. Lookup & Reference
    9. Math & Trig
    10. More Function
  2. Defined Names group command contains the following commands to work in Excel 2013:
    1. Name Manager
    2. Define Name
      1. Define Name
      2. Apply Names
    3. Use in Formula
      1. Paste Names
    4. Create from Selection
  3. Formula Auditing group command contains the following commands to work in Excel 2013:
    1. Trace Precedents
    2. Trace Dependents
    3. Remove Arrows
      1. Remove Arrows
      2. Remove Precedents Arrows
      3. Remove Dependent Arrows
    4. Show Formulas
    5. Error Checking
      1. Error Checking
      2. Trace Error
      3. Circular References
    6. Evaluate Formula
    7. Watch Window
  4. Calculation group command contains the following commands to work in Excel 2013:
    1. Calculation Options
    2. Calculate Now
    3. Calculate Sheet

List of all commands that contain Toolbar Formulas in Excel 2013