If the list is a single column (say A1:A10), you can put a formula in the
adjacent cells (say B1:B10):

Put this in B1:
=rand()
and drag down to B10.

then select A1:B10 and sort this range by column B.

If you want to mix them up again, just recalculate to get new random numbers and
sort once more.

overthehill lady wrote:

I am a teacher and I use vocabulary lists. I would like to know if there is a
way to mix up a list of words so that they do not appear in the same order
all the time.

--

Dave Peterson