Learn how to use this method for fast and easy formulas.
bang out an equal sign( = )into acellto start the formula.
opt for first cell to be added to the formula.
Lifewire
The cell reference appears in the formula and a dashed blue line appears around the referenced cell.
grab the second cell to be added to the formula.
The cell reference appears in the formula and a dashed red line appears around the second referenced cell.
Continue adding operators and cell references until the formula is finished.
PressEnteron the keyboard to complete the formula and view the answer in the cell.
The results are the same and it is really only a matter of preference as to the method chosen.
The cell reference for that cell is added to the formula after the equal sign.
Use the arrow keys on the keyboard to navigate to the second cell to be used in the formula.
The second cell reference is added to the formula after the mathematical operator.
