Forum Discussion
darleenarmour
Aug 03, 2021Copper Contributor
multiplying in excel using auto sequencing and no formulas
I have to create a simple multiplication table in Excel using auto sequencing and no formulas using the least amount of steps. Any ideas?
PeterBartholomew1
Aug 03, 2021Silver Contributor
I see no logical reason why you should have to do this. That said
- Enter a 0 and drag across to give a row of zeros;
- On the next row, enter 0, then 1 and drag across to give a number sequence;
- Select both rows and drag down to increment each column and produce the table.