Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

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.multiplication-table-1

  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.multiplication-table-2

  5. Paste the formula into those cells (Crtl + V).multiplication-table-3

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.