Auto-insert Column or Row to a Table

[Kaushik Joshi]

hello all,

While working with Tables, whenever data is entered after last row or column the table Auto inserts a Row or Column respectively. I selected "Stop Auto inserting rows & columns" from the adjoining drop down message, by mistake. How to get it back? I am unable to find the appropriate Setting for the tables.

for eg in attached Sample file, I want Table Column auto entered when i type "xyz" and a Table row auto entered when i type "abc".

 

[Villalobos]

Hi,

Enable the function: "Include new rows and columns in table", try this: File -> Excel Options -> Proofing -> AutoCorrect Options -> AutoFormat As You Type -> Apply As You Work

 

[Kaushik Joshi]

hi Thomas,
Thanks for this quick fix!! Was getting quite handicapped without this option!!
Have a great day!

Josh