Apply as you work --- Include new rows and columns in table - not functioning on one worksheet only

[steve.waye]

Hi all,

I have a workbook with multiple worksheets that have tables in each worksheet.

I have the following setting turned ON...

• Excel Options --- Proofing --- AutoCorrect Options --- AutoFormat As You Type --- Apply as you work --- Include new rows and columns in tables

When I enter data into the row immediately below a table, a new row should be added to the table. This is NOT happening. The new data is sitting outside the table (which means it cannot be sorted or filtered).

This does NOT happen with tables on other worksheets in the workbook. The functionality is working fine so the abovementioned setting seems to be active.

Any ideas?

Steve

 

[steve.waye]

Hi all,

I have a workbook with multiple worksheets that have tables in each worksheet.

I have the following setting turned ON...

• Excel Options --- Proofing --- AutoCorrect Options --- AutoFormat As You Type --- Apply as you work --- Include new rows and columns in tables

When I enter data into the row immediately below a table, a new row should be added to the table. This is NOT happening. The new data is sitting outside the table (which means it cannot be sorted or filtered).

This does NOT happen with tables on other worksheets in the workbook. The functionality is working fine so the abovementioned setting seems to be active.

Any ideas?

Steve

I found the solution about 2 minutes after I created this post.

Another user had inadvertently shrunk the first row under the table to a height of "0" so I was actually adding the new record to the second row. I found it by accident when I used right-click to add a new row about 3 rows up and the bottom row just disappeared.

I've been using Excel for close to 30 years and this is the first time this has happened.

Instead of deleting the post I though I'd leave it here and add the solution in case someone else falls into the same trap.

Regards, Steve