I have a worksheet with approx. 37000 account numbers.

I need to format another sheet to pull these numbers into a text format, no
problem.

My question: When I want to copy a formula into all 37000 rows, what is a
quick way to select row 1 thru 37000 and paste the formula without scrolling
for 10 minutes?

P.S. I don't want to select the entire column.