### Excel 2010 Formula Bar

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.

1. I enjoy reading youor articles. You really have a wonderful blogs. Keep up the good work. Thank you also for the information!

Sed
www.gofastek.com

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

www.triciajoy.com

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

Bob
www.gofastek.com