How to Randomize the Contents of a Column in Excel. Suppose you have an Excel spreadsheet with a single column A and 52 rows. The value in each row's cell represents a playing card, for example K ...