Excel columns editability

0
When we click on Export to excel a excel file will get download, that downloaded file should have option that only limited columns should edit. I tried protecting sheet option in Excel template, but it's not working all fields are getting non-editability. can anyone help me please
asked
1 answers
0

Try using the Sheet Protection feature in Excel to restrict editing of certain columns. To do this, select the columns you want, then right-click and select Protect Sheet. Then set a password and specify which cells should remain editable. This way, only the selected columns will be editable and the rest will remain protected.

answered