Forum Discussion
Ed Canvasser
Mar 29, 2017Copper Contributor
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...
Ed Canvasser
Mar 30, 2017Copper Contributor
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??
SergeiBaklan
Mar 30, 2017Diamond Contributor
Hi Ed,
This option doesn't work on protected sheet (as in you case). If unprotect it when no problems