Forum Discussion
Cannot insert or delete rows in a table
Hi henk_buurman
It might be difficult to assess the situation without the snapshot of the screen.
If there is no confidential data in the file, you can share, so we can take a look together.
Cheers
thanks for replying. I have added to snapshots. As you can see, it is a sheet with ~70 columns and currently 200 rows that is used to plan IT colleagues on various projects. First column are names and fifth column are projects, blanked for obvious reasons. First pic shows right click on row <36 and second pic right click on row >35.
Thanks
Hi henk_buurman
I believe the problem can be resolved by selecting the table rows itself instead of the Excel row.
Selecting the Excel rows will disable the insert and delete options when there is another table on the other side of the table. See below:
However, if you select the rows in the table, both delete and insert options are enabled, even though there is another table beside the current table:
I hope this resolves the issue.
Cheers
If only the reason is in second table. That could be more exotic issues, but without the file it's hard to say.
One of possible reasons if you have another table somewhere to the right or to the left. For example, for such combination
row delete/add menu will be greyed for rows from 7 to 12 and active for all other ones
and
