how do I autocomplete columns
 

Excel allows me to autocomplete similar values or formulae below the active
cell by double clicking the bottom right corner of the fill handle. The fill
stops last at the last cell populated in in the column left of the active
column.
How do I do the same thing filling the data to the right of the active cell
stopping the fill at the last entry of data in the row above the active row.
Thanks
Andrew