Home - Information Services - Get Help - How-to-Guides - Excel 2016 - Randomize Rows of Data

Randomize Rows of Data

1. Insert a new column to the left of the first column.
   
   
2. In the new column, click the blank cell for the first record.
   
   
   
3. Click Insert Function.
   
   
4. Under Search for a function, enter RAND.
   
   
5. Click Go.
   
   
6. Click OK.
7. Click OK.
   
   
8. Copy the formula down the column.
   
   
9. Click on a cell in the first column that contains data.
   
   
10. On the Home tab, click Sort & Filter and select Sort Smallest to Largest.