Forum Discussion
Excel 2016 - Can't turn off table autoexpand feature
I've checked and unchecked the options in AutoCorrect option (File->Options->Proofing->Autocorrect->Autoformat as you type), but the table still expands automatically. Is there another setting I'm m...
Hi Ed
I went to the same place as you File->Options->Proofing->Autocorrect->Autoformat > and unchecked "Include new rows and columns in table"
It then stops adding automatically for me.
I went to the same place as you File->Options->Proofing->Autocorrect->Autoformat > and unchecked "Include new rows and columns in table"
It then stops adding automatically for me.
As I mentioned, I've already tried this... doesn't change any functionality of the table. Rebooted computer, checked for any program updates, and started new blank worksheet and still no change.
Can someone please look at this file and see if they can reproduce the problem I'm having?
- Just tested this on another computer in our office w/ latest version of Excel 2016 and same thing... checking or unchecking the settings in 'AutoFormat As You Type' in the document Options/Proofing screen has any impact on how tables function... Can someone on the latest version of Excel 2016 test this to confirm??
Hi Ed,
This option doesn't work on protected sheet (as in you case). If unprotect it when no problems
