How do you randomly shuffle a column in Excel?

Answer 1

You can't randomly shuffle a column in Excel. Given the nature of spreadsheets, that would not always be a sensible thing to do. If you want to be able to generate a random set of numbers, then you can use the Randbetween function. It will give you a set of random numbers between two values that you choose. For example the following will give you a random number between 1 and 100.

=randbetween(1,100)

Every time you adjust any value on the spreadsheet, or press the F9 key, it will select a new set of random numbers. This can be useful for testing formulas without having to put loads of numbers in over and over again. If the function is not available, and returns the #NAME? error when you try to use it, install and load the Analysis ToolPak add-in, which you can do by choosing the Add-Ins option on the Tools menu.