Forum Discussion
Office 365 Excel stopped auto-expanding a table
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!
I tried this and it was checked but still not adding new rows automatically. It would add columns, but not rows, which told me something else was preventing the rows from getting added. Turns out if you you check the "Total Row" feature (Table Design toolbar > Table Style Options) of a table, add anything to that total row, then uncheck the "Total Row" feature to hide it, it will still prevent a new row from being added to the table, even though the Total Row is hidden.
When I checked the "Total Row" to show it, deleted all my content in the Total Row, then hid the Total Row again, the Table then started automatically creating new rows when text was entered immediately below the table.
- Sounds like a bug to me. Perhaps you can click Help, Feedback, I don't like something and tell them so?
- 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.
JKPieterseThat option does not exist on Excel for web. I will open it on the desktop editor and see if that is enabled
