Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547

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 Excel Option Setting so that new columns and rows in an Excel Table are automatically added to the Excel Table Object:
Options setting: File, Options, Proofing, Autocorrect Options, AutoFormat As You Type, check the textbox named “Included New Rows and Columns in Table”.

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.