After entering the formula in cell C1, use the fill handle to drag the formula down from C1 to C5. Each cell in column C will now contain the result of dividing the corresponding value in column A by the constant value in A7. Divide a Column by a Constant Number Using Paste Special A...