Table not auto-expanding

Hi, I think I have switched off some kind of feature in my Excel and I dont know how to turn it back on...
I have various sheets that use tables, but it seems that, for whatever reason, my tables have stopped automatically expanding to the next row down when i fill in data.

Can someone please let me know what stupid thing I have done and how to fix it?

Sorry if this is posted somewhere - I did try to look using a few keywords

Thanks, Tina

Hi Tina, that sounds like a nightmare

Try steps below:
1. Click on the [Office Button] (the small little icon located at the top-left corner of your Excel, or simply press CTRL+F)
2. Click [Excel Options]
3. Select [Proofing] on the left pane, and click on [Auto Correct Options...] button on the right
4. Check [Include new rows and columns in table] under the [Apply as you work] title
5. Click [OK] all the way out, does it work?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Yep! Just figured it out by asking a colleague and was coming back to post - but yes, your info above is exactly what needed to be done! Thank you!

You're welcome, thank you for the reputation and remember to mark this thread as [SOLVED] if not done so



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin