Here's an extension to the earlier set-up if we want generate more than 1
randomized shuffle at one go, using Data Table ..

Assuming the earlier set-up is in Sheet1

In a new Sheet2
--------------------
Put in A3: =Sheet1!B1
Copy down to A12

Put in B2: =COLUMNS($A$1:A1)
Copy across to say, K2
(assume we want to generate 10 sets at one go)

Select A2:K12
Click Data Table
Enter in box for "Row input cell": A1
Leave "Column input cell" box empty
Click OK

What we'll get in B3:K12 are 10 randomized sets of words, in B3:B12, C3:C12,
.... K3:K12. (11 sets actually if you include the one in A3:A12)

Pressing F9 will regenerate another 10/11 randomized sets at one go
(Freeze results elsewhere as before)

Extend to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----