Copying the formula to a last cell.

[GN0001]

Is there anyway to copy a formula to the last cell without double clicking the corner of the cell that contains the formula or dragging the cell? My formula is in B2 and I want to copy it all the way down to cell B55000. I don't want to either drag or double click the corner of the cell.


Thanks

 

[Hui]

I assume there is nothing below B2

and Data in A2:A55000

in B2

Ctrl C

Left Arrow

Ctrl Down Arrow

Right Arrow

Ctrl Shift Up Arrow

Ctrl V


or while in B2 you can use the Fill Down Button in the QAT

 

[vijaySharma]

1. Select B2

2. Copy the formula

3. Press F5

4. Type B3:B55000

5. Press Enter / Click OK

6. Paste


You are done...


Max Fastest Way Possbile...


1. Click on B2

2. Click in the Name Box on the formula bar

3. Type B2:B55000 and press Enter

4. Press CTRL+D


~Vijay

sharma.vijay1@gmail.com

 

[Luke M]

@Vijay


Your "max fastest" way can be 1 step faster, as there's no need for step 1. (you select B2 in step 3) *grin*

 

[vijaySharma]

Spot on Luke...however I just included step 1 so that the end user was certain....

 

[GN0001]

Thank you for all the help. It is really useful.

Hui, What is QAT?

Guity

 

[Hui]

Quick Access Toolbar

http://chandoo.org/wp/tag/quick-access-toolbar/

 

[GN0001]

Thank you very much.