How to drag a formula in the entire column in excel

Thanks a million Clayton. This will definitely help me to do many Excel automation activities easily