To achieve this, you will most likely have to use a script, create a function to read the contents of your Excel spreadsheet, store all the values into an array. Generate a random number, this will be the index value to retrieve the item from the array.
There will be plenty of examples on the Internet, such as https://www.w3schools.com/JS/js_random.asp , https://www.w3schools.com/JS/js_arrays.asp , https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/index.html
