How to arrange excel tables in disorder

1. First, we open the excel table.

2. Enter the formula =rand (), and then press Enter to display the result.

3. Drag the mouse down to make all tables have results.

4. Then click Sort and Filter-Ascending Order. At this point, all the results are unordered.

5. Note: rand () is a randomly generated function, and its numerical value is greater than or equal to 0, but less than 1, and it is variable.