Wednesday 29 April 2020

How to protect specific cell in excel- ITSolution4U

There are following steps for that

Step-1: First of Open Excel Sheet.
Step-2: Right Click on cell that you protect cell -> Click on "Format Cell.."
Step-3: Click on "Protection Cell" and Tick "Locked" check box.


Step-4: Now, click on "Review Menu" -> Click on "Protect Sheet"
Step-5: Un check "Select Locked Cell".
Step-6: Fill up Password with confirmation and then Ok.
Step-7: Now, Click on "Unprotected Sheet" and fill given password.
Step-8: We can access cell that you want to update your data. First of all Right click on cell you want to give update rides-> Click on "Format Cell.."-> Click on "Protection".
Step-9: Uncheck "Locked" checkbox -> Click on Ok button.

 Step-10: Click on "Protect Sheet" and same procedure.

Note: If You will want to more information, Please mail me on "info@itsolution4u.in"

How to insert or embed an Outlook mail with Symbol in Excel - ITSolution4U

 We are facing problems in insert or embed an Outlook mail with Symbol in Excel. So, How to resolve it? We provide step-by-step solutions as...