Table : insert row or colom automatic expends table

New Contributor


When I fill in a new value just below or at the side of my table, it used to expend the datarange automatically. This automatic enlargment does work anymore. How can I solve it ?

Thank you

2 Replies


Select File > Options > Proofing.

Click 'AutoCorrect Options...'

Activate the 'AutoFormat As You Type' tab.

Tick the check box 'Include new rows and columns in table'

OK your way out.