mdjcad@hotmail.com
Do you want the whole table to be sorted randomly?
1, if there is, you add a column of g.
2. Enter the formula =rand () in G 1 to generate a random number, and place the mouse in the lower right corner of G 1. After the+sign appears, hold down the left mouse button and drag it to the end of the table.
3. Select the whole table and sort by column G (Data on the menu-Sort). Whether it's rising or falling. Every time you press F9, the whole table will be rearranged.
4. If you want to sort by column E, just select the whole table, and then sort by column E (Data-Sort on the menu).
Supplement: According to the three points I mentioned above, we can meet the requirements of random sorting, and the fourth point can produce E-column sorting. Both methods sort by the whole line and will not disturb the contents of a line.
You should select the whole table before sorting. Click the blank space in the upper left corner of A 1 to select the whole table. Sorting if you don't select all of them will cause a row of confusion. If only column A is selected for sorting, the contents of column A will be staggered from other columns.