The Formula Bar — Excel Course

Use the Formula Bar to inspect, edit and understand the contents of the selected cell. Learn it step by step with guided practice on Excelquro.

Understand

When you select a cell, its value or formula appears in the Formula Bar. You can click in the bar to edit the expression without losing track of the selected cell.

Worked example

Follow along

1. Select B2.
2. Look at the Formula Bar.
3. Select B3 and compare the expression.
4. Edit B4 through the Formula Bar.
5. Commit the change and verify the result.

Interactive practice runs in your browser.