Step 1 - Open the file
1 - Open the file.jpg


 

Step 2 - Select all cells(Ctrl + A)
2 - Select all cells -Ctrl A.jpg


 

Step 3 - Right Click - then click Format Cells
3 - Right Click - then click Format Cells.jpg

 

Step 4 - Click protection
4 - Click protection.jpg

 

Step 5 - Click unchecked, then click ok
5 - Click unchecked, then click ok.jpg

 

Step 6 - Select the cells you want to lock
6 - Select the cells you want to lock.jpg

 

Step 7 - Again click right - then click Format Cells
7 - Again click right - then click Format Cells.jpg

 

Step 8 - Click Checked, then click ok
8 - Click Checked, then click ok.jpg

 

Step 9 - Click Review
9 - Click Review.jpg

 

Step 10 - Click protect sheet
10 - Click protect sheet.jpg

 

Step 11 - Enter password then click ok
11 - Enter password then click ok.jpg

 

Step 12 - Renter password then click ok
12 - Renter password then click ok.jpg

 

Step 13 - Locked cells cannot be changed
13 - Locked cells cannot be changed.jpg

 


To unprotect sheet 

 

Step - 1 Click Unprotect sheet
For Unprotect sheet - 1 Click Unprotect sheet.jpg

 

Step - 2 Enter password then click ok
For Unprotect sheet - 2 Enter password then click ok.jpg

 

  1. Excel

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 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.