2. Enter the multiple to be expanded in the blank cell.
3. Then enter the calculation formula in cell D 1: =A 1*$C$4, and be sure to add the "$" symbol.
4. Click Enter and drop down the formula to calculate the number of each data corresponding to 8 times expansion.
5. Or you don't need to enter multiple in the cell, just enter the calculation formula: =A 1*8, and drop down the formula to get the same result.