# How to Multiply in Excel

How to Multiply in Excel. Once the magic of Excel spreadsheets is uncovered, it's hard to imagine living without it. Just about any kind of data can be stored in a workbook and manipulated to suit any need. Calculations that once took several minutes to complete by hand now only require a few clicks of a mouse. Multiplication in Excel is a useful tool and the program multiplies numbers in a variety of ways.

## Single Cell Multiplication

#### Step

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.

#### Step

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

#### Step

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.

#### Step

Select the cell containing the multiplier, right click and choose "Copy."

#### Step

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.

#### Step

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.