How to make a 99 multiplication table in Excel2003 by using the simulation table

Do children's shoes look familiar? Yes, when we were kids, everyone had to memorize ... One by one to one; one or two to 222 to four; 13 to 323 633 to nine. Want to make a 99 multiplication table for your child or student so that he can keep it handy? Here's a small compilation to share with you how to use the simulation table in the Excel2003 of the 99 multiplication table.

① Enter the following data in the cell below, as shown in the figure.

② mouse to select B2 cell, and then enter the formula "=if" ($A 2<> ",b$1<>", b$1<= $A 2), $A 2& "x" &B$1& "=" & $A 2*b$1, ""), and then press ENTER to confirm.

③ mouse to position the lower-right corner of the B2 cell, and hold down the left mouse button to drag the fill handle of the B2 cell to the K2 cell.

④ the same way as above, drag the K2 cell's fill handle again to the K10 cell, as shown in the figure.

⑤ the 1th and 1th rows of data are hidden (the left mouse button clicks to select the first row or column, then the right mouse button, select "Hide" in the pop-up menu) to resize, you need to add a border, you can add a border, that is, complete, as shown in the figure.