How to create automatically expanding table in Excel

[ojsevans]

Hello,

I'd like to have my table in Excel automatically add a new row when you reach the final row and press enter. Ideally I would like it to also copy down all of the formulas onto the new row.

The data does seem to be in a table and under Proofing > Autocorrect options the box 'Fill formulas in tables to create calculated columns' has been ticked.

Any help would be greatly appreciated.

Oliver

[grimes0332]

Isn't that what a Table does (Insert Tab/Table) does...?

[ojsevans]

That's what I thought, however my table just isn't doing this for some reason.

I've tried creating a new table from scratch (which isn't ideal but I could do this) which seems to automatically expand out to about 3 rows and then when I press enter again then it jumps to the top. It also isn't copying down any formulas in the next column.

Sorry, I know this sounds like kind of a stupid question but my Excel just isn't playing ball.

I'm using Excel 2013, I'm not sure if this makes a difference as I don't believe I've had this problem previously.

[samba_ravi]

use tab key instead of enter key