**Excel 2010 Formula Bar**

**Introduction:**

**Purpose:**

The

**Formula Bar**allows users display the active cell. Users can use the**Formula Bar**to create functions as well as enter data and formulas into the**Formula Bar**.**Location:**

The

**Formula Bar**is located below the**Ribbon**, to the right of the**Name Box**.**Parts:**

**Cancel Command:**

The

**Cancel****command****allows users to remove any data or function from within the****Formula Bar Text Box**and Excel returns the focus of the keyboard back to the active cell. The**Cancel**command is located on the left side of the**Formula Bar.**If the keyboard cursor is not within the**Formula Bar Text Box**the**Cancel Command**is not visible.**Enter Command:**

The

**Enter****command****allows users to apply the data or function within the****Formula Bar Text Box**to the active cell. The**Enter**command is located on the left side of the**Formula Bar**, to the right of the**Cancel**command and to the left of the**Insert Function Command**. If the keyboard cursor is not within the**Formula Bar Text Box**the**Cancel Command**is not visible.**Insert Function Command:**

The

**Insert Function**command**allows users to search for pre-created Excel functions. Once clicked the Excel opens the****Insert Function Window**. The**Insert Function**command is located on the left side of the**Formula Bar**, to the right of the**Enter**command and to the left of the**Formula Bar Text Box**.**Formula Bar Text Box:**

The

**Formula Bar Text Box**allows users to enter data or functions they want to apply to the active cell. The**Formula Bar Text Box**is located in the middle of the**Formula Bar**, to the right of the**Insert Function Command**and to the left of the**Expand Formula Bar Command**.**Expand Formula Bar Command:**

The

**Expand Formula Bar**command allows users expand the**Formula Bar Text Box**. The**Expand Formula Bar**command is located on the right of the**Formula Bar**. If the**Formula Bar Text Box**is expanded, the**Expand Formula Bar**command is hidden.**Collapse Formula Bar Command:**

The

**Collapse Formula Bar**command allows users to collapse the**Formula Bar Text Box**. The**Collapse Formula Bar**command is located on the right of the**Formula Bar**. If the**Formula Bar Text Box**is collapsed, the**Collapse Formula Bar**command is hidden.
I enjoy reading youor articles. You really have a wonderful blogs. Keep up the good work. Thank you also for the information!

ReplyDeleteSed

www.gofastek.com

Thank you for taking the time to publish this information, very informative. Great job!

ReplyDeletewww.triciajoy.com