How to enter a formula with cell references

Abstract

Transcript

To enter a formula that contains cell references, you have two choices.

Let’s take a look.

For example, we can throw in the formula “=B7+D6” directly.

Notice that you don’t need to worry about case.

When Excel sees a valid reference, it will automatically convert the reference to upper case.

Excel has a nice way of showing you what cells are being referenced in a formula.

Start by typing the formula normally, and click to add references as you go.

To see the highlighting again, just double-click or click F2.

you could also deselect a cell and click into the formula bar.