Select the cell where the formula should be entered.
Type = in the Button image formula bar (equal sign).
Choose one of the following options: choose the cell with the desired value or type the cell reference.
A single cell, a range of cells, a place in another worksheet, or a location in another workbook can all be referenced.
When selecting a range of cells, you can relocate the selection by dragging the cell selection's border, or expand the selection by dragging the corner of the border.
![Range Finder color-codes precedent cells](https://support.content.office.net/en-us/media/8b934088-a523-4e87-aef0-afb194075ed7.gif)