multiplying in excel using auto sequencing and no formulas

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.

I would still prefer

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

when working within a programming environment.

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.