Brian

Frank's double-click works only if there is an adjacent column with data down
to row 37000.

Gord Dibben Excel MVP

On Wed, 15 Dec 2004 08:53:00 -0600, "Brian" wrote:

Frank, thanks for the reply.

But, I double click when the black cross appears in the lower right of the
cell that I have written my formula in and nothing happens.


"Frank Kabel" wrote in message
...
Hi
double click on the lower right corner of your formula cell

--
Regards
Frank Kabel
Frankfurt, Germany

Brian wrote:
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.