Double click on the fill handle, & it will fill down as far as there is data
in the adjacent column.
Otherwise copy, then select the relevant range and paste.
--
David Biddulph

"Erin" wrote in message
...
I know if you click on a cell and wait for the black cross you can fill
handle cells by clicking and dragging, but that takes a while when we need
to
fill thousands of cells. Is there a keyboard shortcut that can drag and
fill
the cells faster?