Learn Excel’s Sequence function to generate numbers, dates, ... For example, if you need a list of numbers from 1 to 100, Sequence can generate it instantly with a single command.

So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

Generate Random Numbers in Excel 3 Simple Functions. Watch this video on YouTube. Unlock more potential in Random number generation in Excel by reading previous articles we have written.