How to randomize Excel rows
===

How can I randomize lots of rows in Excel?  

    For example I have an excel sheet with data in 3 rows. 
    1 A dataA
    2 B dataB
    3 C dataC
    
    I want to randomize the row order. For example
    2 B dataB
    1 A dataA
    3 C dataC

I could make a new column and fill it with random numbers using =RAND() and sort based on that column. 

But is this the best way to do it? The RAND equation will provide up to [a million random numbers][1] and I have a quarter of a million rows so it seems like it would work.  

Thanks 

I searched for a bit and while [this answer about randomizing columns][2] is close it seems like way overkill. 


  [1]: http://support.microsoft.com/kb/86523
  [2]: http://stackoverflow.com/questions/10651553/randomize-columns