How to Randomize (shuffle) a list in Excel Sorting ?

  Excel Interview Q&A

Today we will read on this page how to randomize (reshuffle) a list in Excel sorting?

Create a database such as a snapshot or download an Excel data file.

Select cell B1 and insert RAND () function -> Click on the lower right corner of cell B1 and drag it to cell B8 -> Click on any number in column B -> To sort in descending order, on the Data tab, in the Sort and Filter group, click ZA

Randomize List in excle

Randomize List in excel

LEAVE A COMMENT