To multiply in Excel and show the answer in a cell, select that cell, type a formula beginning with an equals sign, and press Enter—for example, type =6*7 to display 42. Excel uses an asterisk for multiplication. If you mean changing an existing number in place, a formula cannot safely refer to and replace its own cell; use Paste Special with the Multiply operation instead.
This guide covers both meanings of multiplying in the same cell: entering a formula in the cell where you want the result, and applying a multiplier to existing values while replacing them. The steps are for Microsoft Excel for Microsoft 365 on Windows, with notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook with an empty cell for a formula, or values you want to multiply.
- If you are multiplying existing values in place, a cell containing the multiplier and a copy of your workbook or an undo plan. Paste Special changes the selected values directly.
Step-by-Step
- Decide what you mean by same cell. If you want the answer to appear in a particular cell, enter a formula in that cell. The numbers can be typed directly into the formula or referenced from other cells. If you want to take an existing number, multiply it, and keep the result in its original cell, use Paste Special instead. These are different operations: a formula calculates a result, while Paste Special edits the existing value.
- Click the cell where the formula result should appear. Choose a blank cell, such as C2, if your numbers are in A2 and B2. Click the cell itself or select it using the Name Box to the left of the formula bar. Do not type the formula into a cell whose existing contents you need to preserve; entering it will replace those contents.
- Type the multiplication formula. Start with
=, enter the first number or cell reference, type*, and enter the second number or reference. With 6 and 7 typed directly in the formula, enter=6*7in the selected result cell; it returns 42. Press Enter to commit the formula. Excel displays the calculated answer in that cell, while the formula bar shows the formula when you select it. - Multiply values stored in other cells. Put the first value in A2 and the second in B2. Select C2, enter
=A2*B2, and press Enter. With 6 in A2 and 7 in B2, C2 displays 42. This is usually the clearest approach for a worksheet because you can edit either input later and Excel recalculates the result. The formula lives in C2; it does not replace the values in A2 or B2. - Multiply one cell by a fixed factor. If A2 contains 25 and you want to calculate a 10% increase, place the result in B2 and enter
=A2*1.1. B2 returns 27.5. The factor 1.1 represents the original 100% plus a 10% increase. To multiply by a factor stored in another cell, put the factor in C2 and, with the original value in A2 and the result intended for B2, use=A2*C2. For example, 25 in A2 and 1.1 in C2 produce 27.5 in B2. This keeps the factor easy to change. - Fill a formula down a column if needed. After entering a formula in C2, select C2 and drag the small square at its lower-right corner (the fill handle) down the rows you need. If A3 and B3 contain the next pair of values, Excel adjusts the copied formula to use those row numbers. Double-clicking the fill handle can fill down alongside a neighboring column of data. Check the last few results, especially if the adjacent column has blank rows, because those blanks can affect how far Excel fills.
- Apply a multiplier to existing cells and replace their values. First save a copy of the workbook or select the range and note that Undo is available immediately after the operation. Type the multiplier—for example, 3—in an empty cell and copy it. Select the existing values you want to change, then choose Home > Paste > Paste Special. In the Paste Special dialog, under Operation, select Multiply and choose OK. Each selected value is multiplied by 3 in place. For example, a selected cell containing 8 becomes 24. The copied multiplier cell remains unchanged. This method is useful when you deliberately want to replace source numbers rather than keep a live formula.
- Check the result and preserve the right version. Select the result cell and look at the formula bar. For a formula, you should see the expression beginning with an equals sign; for a Paste Special result, you will see the updated value. Confirm the answer against a simple calculation and make sure you have not overwritten source data unexpectedly. Save the workbook when the results are correct.
On Excel for Mac, you can enter formulas in the same way with the asterisk and Enter or Return. Paste Special is available through the Home tab’s Paste controls or the Edit menu; use the Paste Special dialog’s Multiply operation if it is offered in your version. Excel for the web supports ordinary multiplication formulas. If its Paste Special options do not include Multiply, calculate the values in a helper column, then copy the results and paste values over the original range if replacement is intended.
Common Mistakes
- Using x instead of an asterisk. Excel does not use the letter x as its multiplication operator. Type
*between the values, as in=6*7. - Leaving out the equals sign. Without the opening
=, Excel may treat the entry as text instead of calculating it. Start every formula with an equals sign. - Trying to make a cell calculate from itself. A formula such as
=A2*3entered in A2 refers to A2 itself. This creates a circular reference, not a safe way to update A2. Put the formula in another cell or use Paste Special > Multiply. - Overwriting an input accidentally. A formula entered in a cell replaces whatever was already there. Keep inputs in their own cells and put calculated results in a separate location unless you intentionally use Paste Special to change values.
- Using the wrong reference. Check that each reference points to the intended row and column. A formula can calculate without an error while still using the wrong input cell.
- Expecting Paste Special to keep a live link. Multiply in Paste Special changes the selected values. It does not create formulas that update when the copied multiplier changes.
Tips
- Use cell references rather than typing numbers into a formula when the inputs may change. This makes the result update automatically and makes the calculation easier to audit.
- Keep original values if you may need to compare or recalculate later. A separate result column is safer than overwriting the source data.
- For repeated calculations, put the multiplier in its own cell and refer to it. For example, if the input is in A2, the multiplier is in B1, and the result belongs in C2, enter
=A2*B1in C2. With 8 in A2 and 3 in B1, the result is 24. If you copy the formula down and want every row to keep using B1, make that reference absolute: with the same layout, enter=A2*$B$1in C2. It still returns 24 for those example values, and the B1 reference stays fixed when copied. - Format the result to suit the data. Select the result cell and use Home > Number Format to choose an appropriate format, such as Number, Currency, or Percentage. Formatting changes how a value is displayed, not the multiplication itself.
- For whole-number scaling, decimals, or unit conversions, label the multiplier clearly. A result can be mathematically correct but confusing if the worksheet does not explain whether the factor means a rate, a quantity, or a conversion.
- Use Undo immediately if Paste Special changes the wrong range. On Windows, Ctrl+Z undoes the last action; on Mac, use Command+Z. Save a separate workbook copy before bulk changes if you need a reliable way to restore the original data later.
Troubleshooting
The cell shows the formula instead of an answer. Confirm that the entry begins with =. If it does, the cell may be formatted as Text. Change the cell format to General from Home > Number Format, then select the cell, press F2, and press Enter to make Excel evaluate the entry. On a Mac, the key used to edit a cell may depend on the keyboard settings; double-clicking the cell is another way to re-enter the formula.
The answer is 0 or not what you expected. Check the referenced cells and confirm they contain the intended values. A blank cell used in multiplication is treated as zero, so a reference to a blank may make the result zero. Also check for numbers stored as text, which may not behave like numeric values in every calculation. If the displayed number is rounded, increase the displayed decimal places from Home > Increase Decimal to see whether the underlying result contains more digits.
Excel reports a circular reference. This usually means the formula refers to its own cell, either directly or through a chain of other formulas. Move the formula to a different cell and verify that its references point only to input cells. Do not enable iterative calculation just to hide an accidental self-reference; that setting is for specific intentional models and can make results harder to interpret.
Paste Special has no Multiply option, or the operation changes unexpected cells. Make sure you copied a cell containing a numeric multiplier before selecting the destination range. Reopen Home > Paste > Paste Special and check Operation. If Multiply is unavailable in your Excel version, use a helper column with a formula, review the results, and paste values only if you intend to replace the originals. If the wrong range was changed, use Undo immediately before doing other work.
The formula stops working after copying it. Check whether its references should move with each row or stay fixed. Relative references normally adjust as a formula is filled. If a multiplier should remain in one cell, use dollar signs around its column and row, such as $B$1, in the formula. Then copy the formula again and verify that each row refers to the intended input and fixed factor.
Frequently Asked Questions
Can I multiply two numbers and show the answer in the same cell?
Yes. Enter a formula in the cell where you want the answer, such as =6*7, and press Enter. The cell displays 42. The formula calculates a result there; it does not also store the two inputs as separate editable values.
Can Excel multiply an existing cell by a number and replace it?
Yes, use Paste Special with Operation set to Multiply. Copy the multiplier, select the existing values, and apply the operation. This replaces the selected values, so keep a backup or use a helper column if you need the originals.
Why can I not put a multiplication formula in the same cell as its input?
A cell can contain either a value or a formula, not both as independent contents. Replacing the value with a formula removes that original value. If the formula refers to the same cell to retrieve that value, Excel sees a circular reference.
What symbol does Excel use to multiply?
Use the asterisk, *, between numbers or cell references. For instance, enter =4*5 in the cell where you want the result; it returns 20. The letter x is not the multiplication operator in a standard Excel formula.
Can I multiply a whole column by the same number?
Yes. For formulas that retain the source values, put the multiplier in a cell and fill a formula down a neighboring result column. To replace existing numbers, copy the multiplier and use Paste Special > Multiply on the selected range. Review the selected range carefully before applying the operation.
Related
- How to Import an Excel Sheet Into Word: 3 Simple Methods
- How to Import an Excel Spreadsheet Into a Word Document
- Import Excel into a SharePoint List: Step-by-Step
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Filter Button Shortcut: Keys, Menus, and FixesIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a…
- Excel Conditional Formatting Formula for DatesIn Excel for Microsoft 365 on Windows, use a formula-based conditional formatting rule to highlight dates that meet…
- Excel Test If Two Cells Are Equal: Formulas and FixesTo test whether two cells are equal in Excel, enter =A1=B1 in another cell, replacing A1 and B1…
- Round Excel Numbers to the Nearest Ten With a FormulaTo round a number to the nearest ten in Excel, use the ROUND function with -1 as its…
- Excel Slicer to Filter Data: How to Set Up and Use ItTo filter data with an Excel slicer, select a table cell and choose Table Design > Insert Slicer,…
- Excel 2019 SUBSTITUTE Function: Syntax, Examples, and TipsExcel 2019 includes the SUBSTITUTE function for replacing specified text inside a cell with different text. Its syntax…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.