This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Not quite sure but when I add a new row it is not automatically included? I have to resize the table,
not sure what done,
so until yesterday if i added something to bottom it would be included , not any more?
I did have to make some changes in options, and may have checked / unchecked something by mistake.
Richard
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET5%3C/text%3E%3C/svg%3E)
selecting cell below and hitting tab
No this is wrong; you need to click in the cell in your new screen shot that contains the letter:-
a
Got it now?
https://stackoverflow.com/questions/19957206/excel-table-not-expanding-when-new-data-is-added If you had formulas or something that got copied down below the bottom of the table, now you're not "adding" new data below and so the table will not dynamically expand. Make sure to clean up any garbage below the table and this should restore functionality.