Select the top cell and double-click the drag square (bottom-right). This copies the top cell all the way down until the data end. Another thing: you can select a large range and type the formula in the Formula Bar and confirm with Ctrl-Enter.
