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.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.