Random Sort in Excel You can generate random numbers in Excel and use them in conjunction with Excel's sorting feature to have Excel randomize a list of data.

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.