So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those numbers, right-click the selected cells, and click "Copy." Alternatively, ...

Generating Random Numbers in Excel . Random numbers can be generated to randomly select a winner from a list of names in a spreadsheet, choose respondents to participate in a survey from a large ...