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

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".

[MFoudz]

DUDE YOU ARE AMAZING! I was working on a massive excel file and seems like this feature switched off for me and I was on the verge of re-installing excel as all my work is built in tables and I couldnt find an answer anywhere and finally I got the answer from your video, I never put comments on youtube but I thought I'd let you know that you made my life more easier.

[chrism]

Good little tip Mike. Mine were checked by default, but if they weren't, I would never think to look there!

[QuickMadeUpName]

Short and sweet. Nice one Mike. Didn't know that one.

[edge]

Cool tip... I would never ever think you can find it there … thank again Mike

[ennykraft]

I had this happen once in an Excel seminar and it took a while till I figured out what had happened. Totally beats me why anybody would uncheck that. It's one of the best features of tables - and there are a lot of them. Great video!

[shoaibja]

Would give more than 1 thumbs up if I could, thanks!

[patov.a]

GOD BLESS YOU. YOU ARE THE MOST WONDERFUL CREATURE I'VE EVER KNOWN

[wayneedmondson]

Hi Mike.. thanks for that hidden gem of a tip. I've never run into it before. I guess by default the feature is checked on and so all the tables I create work as expected. Nice to know if I run into this in the future. As you said, the option toggle does not seem placed in an obvious location. I guess the sister tip here is the checkbox below it which reads: Fill Formulas in Tables to Create Calculated Columns. If that is checked off, then you don't get autofill when typing a formula in a table column. Odd that these are considered "Proofing" by Microsoft. Thanks and Thumbs up!

[Balaskh]

short and to the point, god bless you!

[MalinaC]

Thanks for the option-video! Sometimes even Excel needs "fixing" 😉

[robinnewton]

This did not work for me. Those boxes were already checked and I still have the little blue bracket indicating end of the table two rows up.

[mattschoular]

Thanks Mike....That would have driven me nuts trying to figure that one out...

[OzduSoleilDATA]

HOTDOG! I didn't know about that ... not until today. 😊

[Alexsjusa]

I'm working on a table that previously had the feature and now it's disappeared. The box is checked in options but it still doesn't add the formatting to new rows and columns when I hit enter. I have to manually use that little arrow thing in the bottom right of the table. I did delete a row much earlier in my table, do you think it messed up the formatting?

[ismailismaili]

that is the shortage useful video I've ever seen thank you so so much Mr. Mike

[vida]

Thanks for a quick tip. Never had such a situation when column/row adding is switched off

[elyanebardou]

Hi thanks for this. Would you have any tip please in case the rows add to the table automatically in one table but not in another (in a different tab of the spreadsheet)? Many thanks

[huehue]

Hi, Do you have a tutorial on how to add new columns in an existing excel with no table that is stored in sharepoint? Can't find this anywhere, thankyou!

[DougHExcel]

Nice tip Mike...sometimes Excel just doesn't excel showing us where config changes are...

[SyedMuzammilMahasanShahi]

Well, that's something new and weird place to be. Thanks Mike for enlightening us, like always :P