1. Select all cells(Ctrl + A) in a worksheet.
  2. Right Click -> Format Cells -> Protection -> Uncheck locked.
  3. Select the cells you want to lock
  4. Right Click -> Format Cells -> Protection -> Check locked.
  5. Go to Review -> Protect Sheet -> Add password -> Re-enter password
  6. Locked cells cannot be changed.
  7. To unlock, go to Review -> Protect Sheet -> Enter password
  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail