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)?
Thank you, that was a setting I'd been desperately looking for and failing to find. As ever it's a mystery how it ever came to be switched off. Up to a couple of days ago it was on, then I suddenly lost the feature.
- When you add something to a table, a small popup icon shows which allows you to turn that off. This widget can be activated using (I think) pressing the control key. Maybe this was turned off that way by accident?
JKPieterse Thanks for the tip. I've never noticed the widget, but it's a possibility. I'll look out for it.