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.

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.

Type the cell references in the name box and press enter
(to the left of the column header A and above row header 1)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Brian" wrote in message
...
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.

1. Copy the cell w/the formula.
2. Click on the destination worksheet.
3. Click in the namebox in the upper left and type
A1:A37000.
4. Paste.

HTH
Jason
Atlanta, GA

-----Original Message-----
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.


.

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.

Thanks Peo, worked like a charm.


"Jason Morin" wrote in message
...
1. Copy the cell w/the formula.
2. Click on the destination worksheet.
3. Click in the namebox in the upper left and type
A1:A37000.
4. Paste.

HTH
Jason
Atlanta, GA

-----Original Message-----
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.


.

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.