multiplying in excel using auto sequencing and no formulas

Copper Contributor

I have to create a simple multiplication table in Excel using auto sequencing and no formulas using the least amount of steps. Any ideas?

3 Replies

@darleenarmour 

I see no logical reason why you should have to do this.  That said

  1. Enter a 0 and drag across to give a row of zeros;
  2. On the next row, enter 0, then 1 and drag across to give a number sequence;
  3. Select both rows and drag down to increment each column and produce the table.

I would still prefer

= SEQUENCE(12)*SEQUENCE(1,12)

when working within a programming environment.

@darleenarmour 

Is that a competition who uses less formulas and less steps to generate some result or something else? Less/no formulas could be harder in maintenance.