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.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

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

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel

>