**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

Very interesting story. I didn't find it boring to read. In fact, I really had a lot of fun reading your post. Thanks.

ReplyDeleteBob

www.gofastek.com