Excel Spreadsheet Query.

[Taff]

I am preparing a test paper and need to arrange columns in random order. I know I can arrange the column in alphabetical or numerical order, but I don't want them in any order. The whole point is that the people taking the test have to think, not just reel off stuff they've learnt parrot fashion.

I know I could do this manually by moving individual cells, but why make work and waste 20 minutes if the machine can do it for me?

 

[Canuck]

http://www.fileguru.com/apps/random_mix_rows

Which version of excel do you use? 2003 or 2007?

 

[hops]

try

looking at this towards the bottom of the page.

 

[Taff]

http://www.fileguru.com/apps/random_mix_rows

Which version of excel do you use? 2003 or 2007?

2003 I think.

looking at this towards the bottom of the page.

Gents, your geniuses.