When we want to apply a formula down the entire column in Excel, our first impluse would be to drag it down using our mouse, but in many cases it doesn't work. Let's learn how to auto-copy a formula down in Excel without dragging and ensure there is no error even if there are gaps (blank cells) in the original list. Spend just 2 minutes to master the art of formula auto-copying in Excel and you'll never make costly mistakes again.

Don't forget to like, comment and subscribe if you'd like to see more videos like this one!
For work/training enquiries, email me at: minh@skyaries.com
Support my work: paypal.me/nguyenthihaminh

Happy learning
Nguyen Thi Ha Minh (Sky Aries)

свернуть