Forum Discussion

Copper Contributor

Aug 12, 2020

Cannot insert or delete rows in a table

Greetings everyone. Essentially as stated in the header, with the following additional information: * This only applies to the first 35 rows * No problem to insert or delete rows starting ro...

excel

wumolad

Iron Contributor

Aug 13, 2020

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

henk_buurman
Copper Contributor
Aug 13, 2020
wumolad

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
- henk_buurman
  Copper Contributor
  Aug 13, 2020
  henk_buurman
  - wumolad
    Iron Contributor
    Aug 13, 2020
    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