• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying the formula to a last cell.

GN0001

Member
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
 
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
 
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
 
@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*
 
Quick Access Toolbar

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