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

In this Excel tutorial, we’ll use a dynamic expression with RANDARRAY() at the heart of it to generate a random list of names. By including an input value, you can control the number of random ...

You can edit a drop-down list in Excel using a few different methods. It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits.