Press the mouse button, hold it down, drag the mouse down to cell B52 and release it to copy the random number formula to each cell in column B. 3. Click the square to the left of the first column and above the first row to highlight the entire workbook. Click the "Data" tab in the Ribbon, then "Sort."read more >>