Forum Discussion
Office 365 Excel stopped auto-expanding a table
I've done some searching, but traditional fixes like checking the options (O365 doesn't have those), clearing data under the table, and creating a macro (I shouldn't need to do this to fix what I did...
You're sure the option to auto-expand tables is checked (File, Options, Proofing tab, Autocorrect button, "Apply as you work", "Include new rows and columns in table" check box)?
JKPieterseThank you for the tip about the autocorrect option! I would never have found it buried under "Proofing." A table in one of my files suddenly stopped auto-expanding, and sure enough, that never-before-seen option was deselected. Checking the box immediately solved my problem!