Excel – Super quick way to copy formulas

Posted March 26, 2014

PROBLEM: Having to click and drag…and drag….and drag…to copy a formula down a large number of rows.

SOLUTION: Start using the AutoFill secret shortcut.  You’ll love it!

Excel 2010, 2013 & 2016 – AutoFill to the same point as a neighbouring column

You can double-click the AutoFill handle on the lower right of a cell to copy the cell content down the column into the same number of cells as a neighbouring (adjacent) column.

Example A 

Example A above shows a worksheet with the Total Gross and Tax columns completed.  The cell holding the calculation to find the total net payment is at the top of the Total Net column and is currently selected.  An arrow indicates the AutoFill handle.

Example B

 

Example B shows how double-clicking the AutoFill handle copies the selected cell content down the column.  However it stops when it reaches the point where the adjacent Tax column no longer has cells containing data.

This is a fantastic way to copy data when you have large numbers of rows.  Sure beats clicking and dragging!

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Elevate your Excel game and become a pro with our exclusive Insider Group

Be the first to know about new tutorials, videos, and tips for Microsoft 365 products. Join us now and claim your exclusive bonus, your list of Essential Excel Skills to become proficient in Excel!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>