Name Box and Formula Bar in Microsoft Excel 2019

The Name Box is located under the ribbon on the left side of theworkbook area. Use the Name Box to locate cellsquickly or navigate to named ranges in the workbook. The Name Box can beseen in the following screenshot:

ms office 402

The Formula Bar is located next to the Name Box. This is whereformulas are typed and or viewed. The fx item located on the left of theformula area is the Insert Function icon. There are many ways toconstruct formulas in a workbook, and this is one of the methods to gainaccess to all the available functions in Excel. The Formula Bar can beseen in the following screenshot:

ms office 248

Leave a Comment