Find out how to copy data or formulas down a column instantly in Excel. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Copy-data-formulas-down-column-instantly/167361/182270-4.html?utm_campaign=vzV1zSQGziI&utm_medium=social&utm_source=youtube-earned

This tutorial is from the Excel Tips course presented by lynda.com author Dennis Taylor. The complete course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis.

Connect with lynda.com:

Facebook: http://bit.ly/fbldc

Twitter: http://bit.ly/ldctw

Google Plus: http://bit.ly/gplusldc

LinkedIn: http://bit.ly/linkldc

source

Thank you veeery much.

Yay thank you!

Thank you life saver

But what if double-clicking doesn't work?!??

This was helpful thank you!!!

not working. please guide…

Thanks god I got it, not here..=ctrl+shift+end , then after you can paste (with copied formula) once stroke..

praise the Lord, thanks.

You are awesome! Thank you so so much

im clicking and double clicking and nothing is happening. why?

Works fine when you have data in column J & K but I want to set it up so that column L will show the sum of J & K as I work down the rows. In other words I want to repeat the formula in L down the sheet prior to entering the data in J & K

great vid

Thank you!

All I can say is … SWEEEET!

Do you know why there is no shortcut? I really can't understand Microsoft what the problem is. Do you know if there is a shortcut in Office 2016?