How to lock only cells you want to lock expcet all sheet on excle?


चाहियको सेल मात्र लक गर्ने तरिका .
·  select all the sheet.
·     go to format cell option with right click.
·     go to protection.
·     unchecked lock option
·     then,
·     select required cells which you want to lock.
·     go to cell format
·      click  on protection.
·     checked the lock option.
·     then,
·     go to review tab
·     click on protect sheet option
·     checked all the option you want.
·     save the files.

      

Post a Comment

0 Comments