multiplying in excel using auto sequencing and no formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2602059%22%20slang%3D%22en-US%22%3Emultiplying%20in%20excel%20using%20auto%20sequencing%20and%20no%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2602059%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20to%20create%20a%20simple%20multiplication%20table%20in%20Excel%20using%20auto%20sequencing%20and%20no%20formulas%20using%20the%20least%20amount%20of%20steps.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2602059%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2603045%22%20slang%3D%22en-US%22%3ERe%3A%20multiplying%20in%20excel%20using%20auto%20sequencing%20and%20no%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2603045%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20still%20prefer%3C%2FP%3E%3CP%3E%3D%20SEQUENCE(12)*SEQUENCE(1%2C12)%3C%2FP%3E%3CP%3Ewhen%20working%20within%20a%20programming%20environment.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.