In an adjacent column enter =RAND() then double-click to copy down.

Select all columns and sort on that column.


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 12:16:01 -0700, In a Pickle <In a
wrote:

Can I do a "random order" sort? Not alpha or numeric. I need to mix up a set
of rows that are now in alpha order. Thanks for any help.