Drag down formula, any shortcut?

[Kzug]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,
it's hot today and my tiny brain is overheating a little...
I have a very, very, very large file.
I normally use the drag down to copy formula, but this time I am "dragging down" minutes at the time (146,312 lines)
Is there a shortcut to copy the formula(s) to the last line?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,
it's hot today and my tiny brain is overheating a little...
I have a very, very, very large file.
I normally use the drag down to copy formula, but this time I am "dragging
down" minutes at the time (146,312 lines)
Is there a shortcut to copy the formula(s) to the last line?

One way:

Copy the cell with the formula.

Enter the range in the Name Box (Formula Bar), e.g.:

B2:B146313

Paste.

 

[CyberTaz]

John's suggestion is the simplest & most efficient means of selecting a
range [just make sure to press the return key after typing it into the Name
Box before you attempt to do anything else].

Another option is to select the starting cell then use the Scroll Bar to
view the ending cell & hold Shift while you click it.

Also ‹ rather than copy/paste ‹ you can use Edit> Fill> Down (Ctrl+D) once
you select the range.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Kzug]

First, Thanks to both of you for taking the time to reply.
I did not formulate my question properly enough for John. B1:B1000 will work with a SUM type function, but not with a =PROPER type (text)
It worked like a charm with the Edit>Fill>Down.

Nevertheless, Thank You both for your help.

 

[Marc_]

First, Thanks to both of you for taking the time to reply.
I did not formulate my question properly enough for John. B1:B1000 will work with a SUM type function, but not with a =PROPER type (text)
It worked like a charm with the Edit>Fill>Down.

Nevertheless, Thank You both for your help.

One more way to do this is to simply double-click in the cells lower-
right corner instead of clicking and dragging. This does however
require you to have filled all the adjacent cells.

 

[katie_c]

Another option is to copy the formula, go to the column with the data that runs all the way to row 140000. Hit command + down arrow - this will get you to the bottom of the data as long as you don't have empty cells in that column. Then you can go to the column you want to add the data to and use shift + command + up arrow to select all cells - then paste the formula.