Excel Formulas Tutorial Step 3: Add Cell References Using Pointing
After typing the equal sign in step 2, you have two choices for adding cell references to the spreadsheet formula.
- You can type them in or,
- You can use an Excel feature called Pointing
After typing an equal sign in cell E3 in step 2:
- Click on cell A1 with the mouse pointer to enter the cell reference into the formula
- Type a plus (+) sign
- Click on cell A2 with the mouse pointer to enter the cell reference into the formula
- Press the ENTER key on the keyboard
If you have more than one row or column of data that you need to perform calculations on, it is often possible to copy the first formula to other cells.
The easiest way to do this is to copy formulas with the fill handle.
