Hi LRM,

You can use a simple formula to divide multiple cells by a single control cell in Excel. Here's how you can do it:

1. Select the cell where you want to enter the formula. In your case, it would be cell C7.
2. Enter the formula "
   Code:

   =C6/C$8

   " (without the quotes) in cell C7.
3. Press Enter to apply the formula to cell C7.
4. Now, select cell C7 and drag the fill handle (the small square at the bottom right corner of the cell) down to the last cell where you want to apply the formula. This will automatically fill the formula in all the selected cells.

The dollar sign in the formula "$" before the number 8 makes the cell reference absolute, which means that it won't change when you copy the formula to other cells. This ensures that the formula always refers to cell C8 as the control cell.