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

If you have a list of entries to pick from in Excel 2013, use the Rand() feature to create a random number beside each entry. Sorting the list by this random number scrambles the data, so there's ...

To convert data into a Table, select the data and Press Ctrl + T. Excel provides the Table with a default name, but you can change it by clicking inside the Table to display the Table Design tab ...

And because Excel recalculates formulas every time you press the Enter key and every time you save and exit, the numbers will never be saved anywhere. NOTE: RAND numbers are between 0 and 1.