Dear Team,
I know how to protect sheet. but not able to protect / lock particular cell
/ row and column in Excel. Can you pls help in attached excel sheet how to
do it.
Also pls tell me how to protect Formulas in Excel.
Rgds,
Prabhakar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Respected Prabhakar,
First select all the sheet and go to format tab and go to the protection
tab and uncheck the locked and hidden chechmarks.Then Select the Cells,Rows
or Columns which you want to lock,the go to the format tab and then the
protection tab in the dialog box then check the locked