Table not automatically extending

[SarAExcel]

Hi all,
My tabel in excel has stopped automattically extending when I type into a new row.
Previosuly when I entered data into the next row, the table would automattiocally extend down and all the formulas, formatting, validation etc would also extend.
I'm sure this is something simple but I can't seem to fix it.

Thanks in advance!!!

 

[bschwartz]

Try going to the last cell in the table and tabbing (hit the Tab key) to create new records in the table.

 

[mfexcel]

Go to File --> Options --> Proofing --> AutoCorrect Options...
to the second tab "AutoFormat As you Type"
Make sure the second checkbox "include new rows and columns in table" is checked

Hi all,
My tabel in excel has stopped automattically extending when I type into a new row.
Previosuly when I entered data into the next row, the table would automattiocally extend down and all the formulas, formatting, validation etc would also extend.
I'm sure this is something simple but I can't seem to fix it.

Thanks in advance!!!

 

[SarAExcel]

Thanks for your suggestions.
-mfexcel, I checked this and it was already checked
-bshwartz, when I hit tab it works. And now that I've done that it seems to have fixed itself and is auto correcting as soon as I type into the next row (automatically extending the table). Perhaps someone else using the spreadsheet (its shared) clicked on the auto correct (lightning strike icon) that appears & selected "Stop Automatically Expanding Tables". Well I guess at least I know how to fix it if it happens again.

Thanks for your help

 

[bschwartz]

You are most welcome.

 

[SarAExcel]

SOS!
I can't work out what is going wrong. Now when I extend the table, some column formulas are automatically extended to the new row but there are other columns also containing formulas & for some reason these are not automatically extending to the new row (even when I hit tab).
Any suggestions would be greatly appreciated (I really don't want to have to manually cope the formulas down everytime I add a new row).
Cheers

 

[mfexcel]

you may try input the formula on the 1st row again...

SOS!
I can't work out what is going wrong. Now when I extend the table, some column formulas are automatically extended to the new row but there are other columns also containing formulas & for some reason these are not automatically extending to the new row (even when I hit tab).
Any suggestions would be greatly appreciated (I really don't want to have to manually cope the formulas down everytime I add a new row).
Cheers

 

[SarAExcel]

Thank you so much. That worked!

 

[mfexcel]

You are welcome.

Thank you so much. That worked!