WPS table How to make 99 multiplication table

1: Create a wps table in the A1 column enter the number 1, in the A10 column input formula =if (and ($A 1>=a$1,column () <11,row () <19),a$1& "x" & $A 1& "=" & $A 1*a$1, "") here to explain if for the judgment, and for logical, $A 1 for absolute and relative rows, a$1 for relative and absolute Rows, column () for the number of columns, row () table, that is to say $a1, you can enter the column of 1. The input completion effect is shown in the figure.

2: Select A1 Bar, when the mouse turned black cross, click to pull the mouse to A9, so that 1-9 of the number came out. Effect as shown.

3: Select A10 Bar, that is, just enter the formula column, wait until the mouse turned black cross, click to pull to A18, this time 1 to 9 of the multiplication came out.

4: Repeat step 2, will A1 to I9 all pull out the number out, do not worry about the number is too large, completed after the effect as shown.

5: Repeat the third part, will A10 to I18, all pull out, such a 99 multiplication table is shown in front of us.

6: This time the page is not beautiful, we also want to do things, choose 1 to 9 lines, click Format---line-hidden.

In this way, a 99 multiplication table made out of WPS comes out.