1. First of all, random integers within a specified range can be generated by the randbetween function in Excel, and random numbers within the range of 1 to 100 can be generated in B 1:B4. Select a range and enter a formula.

2. Press Ctrl+Enter to end the input and get a random number.

3. Press F9 and the random number will be refreshed.

4. If you want to generate random decimals, you can consider dividing Randbetween by multiples of 10 to generate random numbers with two decimals between 10 and 100, as shown in the following figure.

5. Finally, you can see that the page generates random data, so the problem of randomly generating data in excel is solved.