Current location - Training Enrollment Network - Mathematics courses - Excel shulte grid below is the generation method of 10* 10 to help make a 5*5.
Excel shulte grid below is the generation method of 10* 10 to help make a 5*5.
1. First, select the required area, such as A 1: E5, adjust it to a 5*5 grid, and set it as the printing area.

2. Enter =RAND () in the grid outside the area, such as G 1, and then drop down 25 lines.

3. Enter = rank (G 1, $ G $ 1: $ G $25) in the required area, such as A 1: E5.

In which G 1 is replaced by G2, G3 and G25, respectively.

Description: Each click will change the contents of the cell. ...

There is almost no possibility of making mistakes. If you are not at ease, you can add a verification cell and enter the following:

=IF(SUM(A 1:E5)=325, "The table is correct", "If there is any error, click to regenerate").