1. First, we open the Excel table and select cells.
2. Then we select the cell, enter the formula "= int (rand () * (100-1+1))+1",and press enter to confirm. (If it is extracted from 1-50, use 50 instead of 100 in the formula, and so on. )
Then we press F9 to refresh, that is, every time we press F9, a new number will appear.