Start by putting an equal sign which will tell Excel youre making a formula. Divide numbers by using cell references. In the worksheet select cell A1 and press CTRLV.
Why using cell references will make it easy to update your calculations if your data should ever change.
Do not select the row or column headers. Sometimes the column you want to apply the formula may covers hundreds of rows and dragging Fill handle may be not convenient. Make sure the divisor in the function or formula isnt zero or a blank cell. The formula below divides the value in cell A1 by the value in cell B1.