Forum Discussion
Marianne_Hansen
Jan 13, 2022Copper Contributor
New columns in a table
Yesterday I did a mistake and clicked "Stop automatic adding columns" in the button of a table. Now I am not able to automatically add columns or rows to a table by writing in the next column or row....
Riny_van_Eekelen
Jan 13, 2022Platinum Contributor
Marianne_Hansen Look in Options, Proofing, Autocorrect Options...
Edit:
It's the second option that affects automatic expansion of a table. The third one affects filling down formulae in a table. On a Mac, similar settings can be found under Excel, Preferences..., Tables & Filters.
- Marianne_HansenJan 13, 2022Copper ContributorYES! This solved my problem! Thank you so much!
- Riny_van_EekelenJan 13, 2022Platinum Contributor
Marianne_Hansen Great! Understandable that you don't find this as it isn't obvious that automatic table expansion options are part of Proofing / Auto Correct.