How to implement random sorting between rows in Excel tables

php Xiaobian Xigua teaches you how to implement random sorting between rows in an Excel table. Through a series of simple steps, you can easily randomly sort the rows in an Excel table, providing more flexibility for data processing and analysis. Follow our guidance and master this practical skill to make your Excel operations more efficient!

1. As shown in the picture, it is the order of appearance in a company's speech competition. Now I want to disrupt the order of appearance and reorder it.

2. Select all employee information cell areas, namely B2:D13.

3. Click the option below.

4. Click [Random Repeat] and select [Random Sort].

5. Check [Sort between rows] and click [OK] to complete.

6. The completed effect is as shown below. If you are not satisfied with the sorting, click OK again to reorder.

Operation method two:

1. Insert an auxiliary column after the table.

2. Enter the formula =RAND() in the auxiliary column cell.

3. Select the cell range B2:E13, click [Data], and select [Sort].

4. Set [Main Keyword] as the auxiliary column and click [OK] to complete the random sorting.

5. The completed effect is as shown in the picture

The above is the detailed content of How to implement random sorting between rows in Excel tables. For more information, please follow other related articles on the PHP Chinese website!