About 6,570,000 results
Open links in new tab
  1. Help from Microsoft
    https://support.microsoft.com/en-us/article/cb2b3292-28bb-43a1-b20d-efb81b208b4e

    Let's say you want to help a child to better understand math concepts by creating a multiplication table. 

    1. Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1.

    2. Enter this formula in cell B2. The $ locks the value for the header row and the formula multiplies it by the value in the row.

      =$A2*B$1

    3. Copy cell B2.

    4. Select the range B2:K11.

    5. Paste the formula into those cells (Crtl + V).

    See moreSee more
    See lessSee less
  2. Microsoft Support
    https://support.microsoft.com › en-us › office

    Create a multiplication table - Microsoft Support

    Let's say you want to help a child to better understand math concepts by creating a multiplication table. Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1.

  3. Automate Excel
    https://www.automateexcel.com › ... › multiplication-t…

    Create Multiplication Table in Excel & Google Sheets

    Feb 7, 2023 · Enter the numbers 1-10 in cells A2 to A11. Select the range B1:K1 and type the following formula in the formula bar. Press …

  4. WikiHow
    https://www.wikihow.com › Create-a-Times-Table-to...

    How to Create a Times Table to Memorize in Excel

    Sep 22, 2025 · In this article, you'll learn to create a Times Table or Multiplication Table in Microsoft Excel, which can be adapted to being a …

  6. YouTube
    https://www.youtube.com › watch

    Create Multiplication Table in Excel - YouTube

    Apr 28, 2021 · How to create Multiplication Table in Excel quick and easily using just one formula?🖱️ Excel Quora Space - …

  7. learnexcelandsheets.com
    https://learnexcelandsheets.com › how-to-make...

    How to Make Multiplication Table in Excel

    Jan 28, 2024 · In this tutorial, we are going to learn how to make multiplication table in Excel. For example, we are making a table of 20 X 10 …

  8. Exceljet
    https://exceljet.net › formulas › multiplication-table...

    Multiplication table formula - Excel formula | Exceljet

    Apr 29, 2023 · Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional …

  9. People also ask
    How to create a multiplication table in Excel?
    The multiplication table can be created by using mixed cell references, where one either the row or column reference is locked and the other is not. Use this formula in cell B2: This will lock the header row for number and will multiply the header column row and will return the result. Then we’ll copy and paste this formula into the entire range:

    Create Multiplication Table in Excel & Google Sheets

    automateexcel.com
    How to create a multiplication table in Google Sheets?
    You’ll just have to select the range B1:K1 and insert of the formula in the formula bar and press Ctrl+Shift+Enter (Excel 2019 and Earlier): In this way, the whole multiplication table will be created. The formula to create multiplication table works exactly the same in Google Sheets as in Excel:

    Create Multiplication Table in Excel & Google Sheets

    automateexcel.com
    How do I calculate multiplication in Excel?
    In cell B2, input the formula "=A2*B1" and press Enter. This will calculate the multiplication of the values in cells A2 and B1. You can then use the fill handle to drag the formula across the entire range of cells to fill in the rest of the multiplication table.

    Excel Tutorial: How To Create A Multiplication Table In Excel

    dashboardsexcel.com
    How to populate a multiplication table in Excel 365?
    Select the range B1:K1 and type the following formula in the formula bar. Press Ctrl+Shift+Enter, because it’s an array formula (not necessary in Excel 365 or versions of Excel after 2019). Now we have the set up for our multiplication table. Below we will demonstrate two ways to populate the multiplication table.

    Create Multiplication Table in Excel & Google Sheets

    automateexcel.com
    How to multiply a number in Excel?
    With this approach, you can quickly multiply numbers, cells, entire columns and rows. To make the simplest multiplication formula in Excel, type the equals sign (=) in a cell, then type the first number you want to multiply, followed by an asterisk, followed by the second number, and hit the Enter key to calculate the formula.

    How to multiply cells in Excel with formula examples

    ablebits.com
    How to calculate multiplication from 11 to 20 in Excel?
    Press the “F9” key on the keyboard if you want to load new numbers, this will change the values automatically. On the last worksheet, you find all multiplications from 11 to 20. So, you can expand your knowledge with these calculations! There is the small multiplication table (1 x 10–10 x 10) and the large multiplication table (1 x 11–10 x 20).

    Multiplication Table Charts with Excel - Excel Template

    excel-template.net
    Feedback
  10. Excel-Templates
    https://www.excel-template.net › multiplication...

    Multiplication Table Charts with Excel

    Jun 24, 2024 · On the first page of the Excel file, you will find an overview of all calculation variations of 1 and 10. Starting with the 1s series up to the …

  11. My Microsoft Office Tips
    https://www.myofficetricks.com › how-to-create-the...

    How To Create The Multiplication Table In Excel

    Sep 21, 2021 · Let’s prepare the frame of the multiplication table. Highlight the area first and type =IF (B$2>$A3,””,B$2&”*”&$A3&”=”&B$2*$A3) in cell …

  12. dashboardsexcel.com
    https://dashboardsexcel.com › blogs › blog › excel...

    Excel Tutorial: How To Create A Multiplication Table …

    Welcome to our Excel tutorial on how to create a multiplication table in Excel. In this post, we will guide you through the step-by-step process of creating …

  13. Ablebits
    https://www.ablebits.com › ... › multiply-excel-formulas

    How to multiply in Excel: numbers, cells, entire …

    Mar 17, 2023 · The tutorial explains how to multiply in Excel by using the multiplication symbol and functions, how to create a formula for …