Here's a keyboard shortcut you can take advantage of: practice a bit
first. Hold down the SHIFT key and press END and the down arrow. This
will highlight the range from your starting point to the first
non-blank cell. So: go to row like 35001 and type an X or your
initials or some other thing. Then go to the first formula cell and
press CTRL-C (to copy it into the clipboard); go to the first cell you
want to copy it to, then hold SHIFT and press END DOWN to highlight the
entire range. Press CTRL-V to paste into that range.

Another alternative is to hide rows 2 ~ 34,999, and then do the the
click and drag thing. Altho the rows are hidden, the formula is still
pasted in.