Excel has ascending and descending order. How to rearrange one or several columns, and make their arrangement order chaotic (that is, random or difficult to see the law)?
Enter the rows or columns of Excel into the random number formula, and then sort them according to the rows or columns where the random numbers are located.
For example, there is a column number, A 1 = 1, A2 = 2, A3 = 3, A4 = 4, A5 = 5, A6 = 6, A7 = 7 and A8 = 9. Enter the formula =RAND () in B 1 and enter it from B65438.