title: How to randomize Excel rows
body: <p>How can I randomize lots of rows in Excel?  </p>
  
  <pre><code>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
  </code></pre>
  
  <p>I could make a new column and fill it with random numbers using =RAND() and sort based on that column. </p>
  
  <p>But is this the best way to do it? The RAND equation will provide up to <a href="http://support.microsoft.com/kb/86523" rel="noreferrer">a million random numbers</a> and I have a quarter of a million rows so it seems like it would work.  </p>
  
  <p>Thanks </p>
  
  <p>I searched for a bit and while <a href="https://stackoverflow.com/questions/10651553/randomize-columns">this answer about randomizing columns</a> is close it seems like way overkill. </p>