How to Multiply in Excel

By Techwalla Computers Editor

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 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.

Step 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.

Step 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

Step 1

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 2

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

Step 3

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 4

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.