Restrict inserting of Rows

[Paul_Castelino]

We use O365 and we share our files via OneDrive and Teams extensively for collaboration. is there a was we can....
1. Restrict inserting ROWS in between Tables. ROWS to added only at the bottom after the Last ROW.
2. Restrict inserting COLUMNS in between Tables. COLUMNS to added only at the bottom after the Last ROW.
3. Disable the Cut, Copy, Paste option.

[#2]

Hi @Paul_Castelino;

If you are collaborating with Excel file then use can try JavaScripts for not allowing the users to insert information and if you are collecting the information then I would recommend you using Microsoft Forms. Once the user made the entries cannot be amended. You can connect your forms using Microsoft PowerAutomate to directly get the forms information into Excel workbook each time the records are added.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more