View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default How do I set up a multiplication table using formulas?

Another way
=B$1*$A2
copy across and down


"Bruce" wrote:

I am trying to demonstrate the usefulness of Excel by showing my kids how it
will calculate multiplication tables for them. Using numbers 1 to 12 (for
example) across the x-axis and 1 to 12 across the y-axis would yield a
product. Any assistance in using formulas?
--
Bruce Schmidt