Prevent to insert new columns into excel sheet

[inokam]

I need to prevent or restrict to add new columns into excel sheet.

 

[DanteAmor]

One option is to protect the sheet andcheck the allowed options and uncheck the restricted ones.

 

[inokam]

Thanks DanteAmor,
But, when I am using this method, it is unable to type data into sheet.

 

[DanteAmor]

Thanks DanteAmor,
But, when I am using this method, it is unable to type data into sheet.

You must select the cells and change the format before protecting the sheet

Menú, File, Format, Format cells.

Under the Protection Tab, uncheck the Locked option and click OK.

 

[inokam]

Hi Dante Amor,
Thank you so much. I did all the configurations as specified in the above steps. but, it is not working. Still, I can add new columns.

 

[inokam]

Hi Dante Amor,
Extremely very sorry for above comment. Now it is working. Thank you so much.

 

[sandy666]

also you can type any text or even space in XFD1 cell and after that it will not be possible to add any column

 

[DanteAmor]

Hi Dante Amor,
Extremely very sorry for above comment. Now it is working. Thank you so much.

You're welcome. Thanks for the feedback.

 

[inokam]

Hi,
Again I have some issue. I did all the things as you mentioned in above. It's working properly. But, after protecting the data sheet, it is not able to add validations by using "Data validation".
I need to prevent insert and delete columns from the sheet. But, should be able to add data validations. Highly appreciate your help.

 

[DanteAmor]

You must unprotect the sheet (administrator's task), add the validation and then protect the sheet.