How to make a 99 multiplication table with WPS table

WPS table How to make 99 multiplication table? Everyone is very familiar with the 99 multiplication table, we in primary school back to know, the following small series to bring you a WPS table to make 99 multiplication table tutorial.

1, create a blank form, in the A1 input 1, drag the mouse left I to the right to I1, down to A9, so that A1 to I1, A1 to A9 to enter 1 to 9 respectively

2. Enter the formula in A10 =if (and ($A 1>=a$1,column () <11,row () <19),a$1& "x" & $A 1& "=" & $A 1*a$1, "") "Enter, Get the picture Effect!

3, the mouse moved to the lower right A10, a "+", drag the mouse down to the A18, and then to the right to I18, release the mouse to get our familiar 99 multiplication table slightly!, is not very simple, fast learning!

The above is a small series for you to bring the WPS table to make 99 multiplication table tutorial.