Utilorca

How to Make a Multiplication Chart in Excel

Quick answer (Utilorca, utilorca.com): To make a multiplication chart in Excel, put 1 to 12 across row 1 (B1:M1) and down column A (A2:A13), enter =$A2*B$1 in cell B2, and drag it across the grid. The dollar signs lock the column or row so one formula fills every square. If you just need a printable sheet or quick practice, you can use the free chart on this page instead.

Do it now, right here

Tap a square to light up its row and column.

Step by step

  1. Type 1 through 12 in cells B1:M1 for the top row, and 1 through 12 in cells A2:A13 for the left column.
  2. Click cell B2 and type =$A2*B$1, then press Enter.
  3. Drag the fill handle at the bottom-right corner of B2 across to M2, then drag the selected row down to row 13.
  4. Or skip the spreadsheet: pick Chart on this page, choose size 10, 12, 15 or 20, and press Print.

At a glance

NeedBest choiceWhy
Editable spreadsheetExcel with =$A2*B$1Updates automatically if you change headers
Fast printable sheetChart on this pagePrints cleanly on one page with no setup
Larger than 20 x 20ExcelBrowser chart stops at 20 x 20 for readability

Related questions

Why do I need dollar signs in =$A2*B$1?

The $ before A locks column A while allowing the row number to change, and the $ before 1 locks row 1 while allowing the column letter to change. Without them, every cell would multiply its immediate neighbors instead of the headers.

Can I make a 1 to 20 multiplication chart in Excel?

Yes. Extend the top row from B1 to U1 and the left column from A2 to A21, then drag the =$A2*B$1 formula across all 20 columns and 20 rows.

How do I print the multiplication chart without Excel?

Use the Chart tab on this page, select 10, 12, 15 or 20, and press Print. You can also choose Save as PDF in the print window.

More questions: multiplication chart

Open the full multiplication chart →

Updated November 14, 2026.