How to protect sheets using password

Step-by-Step Guide

1: Open Your Excel File

. Launch Microsoft Excel and open the file you want to protect.

. Choose the sheet you want to lock.

Step 2: Go to the Review Tab

. Click on the “Review” tab in the top ribbon

. Then click “Protect Sheet

Step 3: Set a Password

. A dialog box will appear

. Enter a password in the “Password to unprotect sheet” field

You can also check the actions you want users to be allowed to do (like select cells, format columns, etc.)

Click ok

Step 4: Confirm the Password

. Excel will ask you to re-enter the password

Type it again and click OK.

And its done

Leave a Reply

Your email address will not be published. Required fields are marked *