How to Multiply in Excel

Single Cell Multiplication
1. Select the cell where the answer will be. You can put a self-contained multiplication problem in one cell anywhere in a workbook and use it just like a calculator.
2. Start with the equals sign in the cell where the answer goes. This is the first step to tell Excel that the cell contains a math function.
3. Use the asterisk sign as the multiplication symbol. Like standard math, insert the asterisk between numbers in the equation with no spaces and hit 'Enter.' The cell should contain the solution to the multiplication problem.
Multiply an Entire Range of Numbers by Another Number
4. Decide what number to multiply the entire data set by and select a random cell in the workbook. This is only a temporary cell entry and is erasable after you complete the function. Enter the multiplier in this cell.
5. Select the cell containing the multiplier, right click and choose 'Copy.'
6. Choose the entire row or column of varied data to multiply. Right click the highlighted row and use the 'Paste Special' function, which brings up a sub-menu window.
7. Click the 'Multiply' option under the 'Operation' section and hit 'OK.' The multiplier now changes all of the data visible in the chosen range within the Excel workbook.