How to Multiply in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to multiply cells using formulas in Microsoft Excel.

Quick summary

This tutorial shows you how to multiply in Microsoft Excel using a simple formula with the asterisk operator. In just four steps, you can calculate products between cells and display results instantly without any manual math.

Steps

Select the cell where you want the answer to appear and type the equal sign "=".
Select the cell where the first piece of data is located.
Type the asterisk symbol "*", which represents multiplication in Excel, then select the second cell.
Press Enter to calculate and display the result.

📌 Why this matters

Knowing how to multiply in Microsoft Excel using cell formulas is a foundational skill for anyone working with numerical data, budgets, or reports. The asterisk-based multiplication formula allows users to instantly calculate products across cells without manual computation, reducing errors and saving time. Mastering this technique enables faster spreadsheet building and lays the groundwork for more advanced Excel functions like PRODUCT, array formulas, and nested calculations.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel