2. First, open the Excel software and create a blank Excel table.
3. Enter "= (ROW ()-1) *10+column ()" in the first cell in the upper left corner, and press enter to generate the first number "1",where "row ()" represents the number of rows in the cell.
4. Select the first cell "A 1" and place the mouse in the lower right corner of the cell. When the mouse becomes "+",hold down the left mouse button and drag 9 cells to the right to generate the first row of numbers 1- 10.
5. Select ten cells in the first row where the number has been generated, and place the mouse in the lower right corner of the tenth cell "J 1" in the first row. When the mouse becomes "+",hold down the left mouse button and drag down 9 lines to generate the remaining 90 numbers.
6. Finally, add a border to the table, adjust the cell size, and then complete the production of one hundred tables, which can be printed for use.
Extended data:
Common ways to play hundreds of tables:
1, let the children tell the laws and connections between each row and column of numbers;
2. Cover all the squares, open the number of one square and let the children say the number of the adjacent square;
3. Cover multiple squares and say one for the child to find;
4. Say the sum of several numbers and let the children find out which numbers are made up.
5. Give the number of rows and columns in the grid and let the children say the numbers in this grid.
Baidu encyclopedia-baizhuo