In an empty column, enter

=RAND()

and copy down as far as you need to go. Then, sort by that
column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jayyyyyy" wrote in message
...
How do I randomize rows in Excel?