How do I randomly sort a range of data?

Let's say you have data in A2:D50, with headers in A1:D1

Select E2:E50.

Enter the formula =RAND()

Confirm the formula by pressing Ctrl+Enter.

Select E1.

Enter a dummy header, for example "Random".

Sort the data on column E.