How to shuffle the order in excel

How to shuffle the order in excel

1. First copy the content in the text to any column in Excel , such as column A;

2. Then select any other column, such as column B, enter the formula =rand() in the empty column of column B; press Enter and fill down;

3 .Click to select column B, then click "Data", then click "Sort", select "Expand Selected Area", then click "Sort", select "Column B" as the main keyword, and then click OK.

At this time you will find that the order of your column A has been completely disrupted, achieving disordered arrangement.

For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn to learn!

The above is the detailed content of How to shuffle the order in excel. For more information, please follow other related articles on the PHP Chinese website!