Click and hold the square in the bottom-right corner of the cell and drag it down to create 20 values. Excel will create a series of random numbers between 1 and 20 in randomized order. In the unlikely event that you get a duplicate random decimal in your first row, type = in any empty cell and press Enter.