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