Autofilling inserts new rows

Question

Hello

I came across an Excel sheet shared by a colleague. The sheet had filters enabled. The first column in the sheet was S.No with numbers from 1 to 540. For some reason the filters in this column stopped at 512. 

We tried autofilling from 1 to 540 to nullify any data type error/missing numbers etc. But beyond 512 from 513 onwards, it would start inserting new rows. If we autofill let's say 10 rows from the row 513, beyond 513 it will start adding 10 rows. The problem seemed to be limited to row 513. From 514 onwards the autofill will continue as normal. We confirmed that there were no blank/hidden rows/columns. 

We eventually fixed this by deleting and redoing this row. Once the rows were fixed the filter repopulated to show all the values upto 540.

But I'd love to know why autofilling on that particular row kept inserting new rows. I searched everywhere but couldnt find a clue about this response to autofill. What caused this glitch, if it were a glitch that is? 

P.S- I noticed that while we were inside the table, the Table menu popped up on top. What does this mean? Is it indicating a particular kind of table in Excel? The options on the tab included Slicers. Does this mean it may have  been a pivot table?

Thanks in advance

LV

Answer 1

Hi LV,

Thanks for your updates.

Normally, normally Table will not cause the feature.

If you need further help, could you please provide the affected file, I will check it on our side.

You can upload the file on OneDrive, then share the link with us.

Regards,

Qing

Answer 2

Hi Qing

Thank you for your response. 

To answer your queries

1. I had checked the formatting on the row. But nothing stood out. All the cells except date entries had Generam data type and no other formatting except Center Alignment.
2. I can ask my colleague to provide a screenshot. I figured out that the Table menu appears when the selected cell is inside an Excel table. I'm just wondering if it being a Table caused this to happen. 

Continuing my investigation into this.

Thanks

LV

Answer 3

Hi LV,

Thanks for posting the question on our forum.

According to your description, the issue only affected the special row, I would like to confirm if your colleague set the special format or settings for the row.

Normally, we didn’t meet the issue for the special rows.

As the issue has disappeared now, we may not to check what reason caused the issue.

About the question Pivot table, could you please provide the screenshot of it?

Besides, you can also confirm if you colleague also met the issue.

Regards,

Qing