joykvm.blogg.se

And an Encrypt Document dialog box pops out, type your password into the Password text box, see screenshot:Ĥ. If in Excel 2007, you need to click > Prepare > Encrypt Document, see screenshot:ģ. Click File > Info > Protect Workbook > Encrypt with Password in Excel 2010 / 2013, see screenshot: Launch your workbook that you want to set a password.Ģ. Here is another method can help you to set a password for the Excel document, do as this:ġ. Set a password to protect the workbook with Info command

Note: If you want others read your workbook only and cannot modify the workbook, you can let the Password to open text box blank and set a password in the Password to modify text box in the step 3. And then click OK to close the above two dialog box, it will return to the Save As dialog, then click Save to save the workbook with its password.Īnd the Excel file will set the password, when you launch this workbook next time, you need to enter the password to open it. Then enter your password in the Password to open text box, click OK button and then confirm the password again. Click File > Save As in Excel 2010 / 2013, (if you use Excel 2007, please click button > Save As) and a Save As dialog box will pop out, click Tools drop down list, and click General Options, see screenshots:ģ. Open your workbook that you want to set a password.Ģ. With the Save As function in Excel, you can set a password to prevent other users from opening or modifying the workbook, please do as follows:ġ.

Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!