How To Randomize A List In Excel Easy Steps To Shuffle Data

For example, if your list is in column B and there’s currently data in column C, right-click C above column C and select Insert.

Another option is to use the RANDBETWEEN function, which lets you generate whole integer numbers between any two numbers. For example, if you have 75 rows in your list and want each row to have a unique number between 1 and 75, you’d use =RANDBETWEEN(1,75). [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

You can also click and drag the square at the bottom-right corner of the cell all the way down to the end of your list.

Each time you click the Sort option, your list will randomize accordingly.

Each time you click the Sort option, your list will randomize accordingly.

Each time you click the Sort option, your list will randomize accordingly.

Deleting the column: Right-click the column letter and select Delete. Clearing the column: Right-click the column letter and select Clear Contents.