Make 99 multiplication table by utilizing Jinshan WPS form

Smart niece learned to 99 multiplication table, see me back to listen to me, but also I give her a big, because the multiplication table in the pencil box is too small. How to do? We can not eliminate the enthusiasm of children to learn it!

I used the WPS form to make a 99 multiplication table for my niece. My approach is this:

1, create a blank form, in the A1 input 1, drag the left mouse button to the right to I1, down to A9, so that A1 to I1, A1 to the A9 within the input 1 to 9 respectively (Figure 1):

Figure 1

2, A10 input formula "=if (and ($A 1>=a$1,column () <11,row () <19),a$1&" x "& $A 1&" = "& $A 1*a$1," ")"

3, the mouse moved to the lower right A10, a "+", drag the left mouse button to the right to I1, and then down to the I18, so that the A10 to the I18 region of the formula quickly copied. A 99 multiplication table is present in front of us (see Figure 2):

Figure 2

4, in order to be beautiful, we can hide the A1 to the I9 area, the specific operation is as follows: Select the A1 to I9 area, click the Format menu, select "Line" in the Drop-down menu, click "Hide" in the row (Figure 3):

Figure 3

This article pictures from Jinshan

Explanation of the formula: if for judgment, and for logical, $A 1 is absolute and relative, a$1 is relative and absolute, column () is the number of columns, row () represents the number of rows, and "&" is a text connector.