How to randomize lists in Excel Insert a new column. Insert a column next to the column you wish to randomize. ... Input the formula. In the first cell of the column you inserted, type in the RAND formula, which is "=RAND()". ... Sort column in ascending order. ... Changing the randomization. ... Stop the randomization. Jun 24, 2022