To multiply a column of numbers by the same number, proceed with these steps: Enter the number to multiply by in some cell, say in A2. Write a multiplication formula for the topmost cell in the column. Double-click the fill handle in the formula cell (D2) to copy the formula down the column.
For More Information Please Refer: