Excel Table NOT Automatically Copy Formula Down Column? Option Setting to Fix This. Magic Trick 1548

Download Excel Start Files: http://bit.ly/2IkLpOb
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to change the default setting for copying formulas in Excel Tables down Calculated Columns.
Options setting: File, Options, Proofing, Autocorrect Options, AutoFormat As You Type, check the textbox named “Fill formulas in tables to create calculated columns”.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.