How to copy a formula in Excel for the entire column without dragging #minhacademy #msexcel

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!

Happy learning
Nguyen Thi Ha Minh (Sky Aries)

[anandhuever]

Thank you so much.I have been dragging much lately.

[EliteSniperFMJ]

Im not a fan of tables because weird stuff happens to giant data sets from time to time and i cant see it until i produce charts or comparison reports. I just found a method to copy the top cell, use the name window to the far left of the formula bar, after copying the data go to that cell add ":" then final cell in range, enter then ctrl+V to paste the formula into all cells. In my case i called the top cell from a range in another work book so i had to alter the pasted data to remove "$" for the column number such that reference would change while copying data down properly.

[judyl.]

this is exactly i'm looking for.
btw, is there a way to auto copy the formula all the way down without making it into a table?

[hafizorganicproducts]

By double click it goes to all columns weather they are empty

[tommyharris]

DOES NOT WORK. I keep getting a #VALUE error in my filtered list.