Excel Table Not 'dynamically' expanding.

Question

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

Answer 1

Just found it but not sure how I changed it in first place, but for anyone else who searches,

it seems go to Options Proofing; and check include new rows and columns

If anyone knows how I might have disabled this as I don't remember going near the dialog box I would be interested to know.

Richard

Answer 2

I included the screen shot,, I just added a new row by adding something at the bottom

• well that's no good as you can see from your screen shot.

I did not need to use tab.

You've got to use TAB otherwise you'll end up in exactly the same situation as shown in your screen shot.

Answer 3

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

You haven't told us exactly how you tried to add a new row but if you want to do so you should normally go to the last row of the existing table and click the cell on its far right-hand column and then just hit the TAB key.

Answer 4

I included the screen shot,, I just added a new row by adding something at the bottom

and i was included as it is now, I did not need to use tab.

Answer 5

I'm not sure what you mean about tab

selecting cell below and hitting tab does not get the cell added to the table whcih is what you seem to imply

Nor does this select and tab add a column

I'm more interested in any keyboard shortcuts I may have hit to turn off the automatically include in the first place.