How do I password protect an Excel spreadsheet in Windows 7?

Select File > Info. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.

How do you protect excel with password in 2007?

Protect the workbook structure

1. Click Review > Protect Workbook. Note: The Windows option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. …
2. Enter a password in the Password box. …
3. Select OK, re-enter the password to confirm it, and then select OK again.

How do I protect an Excel spreadsheet with a password?

Protect an Excel file

1. Select File > Info.
2. Select the Protect Workbook box and choose Encrypt with Password.
3. Enter a password in the Password box, and then select OK.
4. Confirm the password in the Reenter Password box, and then select OK.

How do I password protect an Excel 2007 file as read only?

Read-only Workbook

1. Click on the Tools button and click General Options.
2. In the Password to modify box, enter a password and click OK.
3. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don’t enter a password and check Read-only recommended.

How do I change a password on an Excel spreadsheet?

Change a workbook password

Open the workbook that you want to change the password for. On the Review tab, under Protection, click Passwords. In the Password to open box or Password to modify box, select all contents. Type the new password, and then click OK.

How do I open an Excel spreadsheet if I forgot the password?

How to unprotect a password protected worksheet.

1. Step 1 Press ALT + F11 or click View Code on the Developers Tab.
2. Step 2 Double click on the worksheet that is password protected.
3. Step 3 Copy and paste the code below into the (Code) window. …
4. Step 4 Click on the Run Button or press F5.

How do I remove a password to open an Excel file?

On a PC

1. Open your encrypted Excel spreadsheet, type in the password, and click “OK.” …
2. Click on the “File” tab, then click on “Info.”
3. Click on the box labeled “Protect Workbook” to open a drop-down menu. …
4. Delete the password that appears, so that the field is blank.

25 нояб. 2019 г.

How do you password protect Excel but allow read only?

Here’s a step-by-step guide on how to add a password to make your Excel workbook read only.

1. Open the workbook and click the “File” option. …
2. The “Save As” dialogue box will pop up. …
3. Doing so will open up the “General Options” dialogue box. …
4. You’ll be prompted to confirm the password.

How do I make an Excel 2010 file read only?

How to create a ‘READ-ONLY’ file

1. Go to the ‘File’ tab and select ‘Save As’.
2. Select ‘Browse’
3. Click on the ‘Tools’ dropdown at the bottom of the ‘Save As’ dialog box.
4. Select ‘General Options’ from the list.
5. Make sure the ‘Read-only recommended’ box is checked in the ‘General Options’ dialog box and click ‘OK’
6. Select ‘Save’.

8 окт. 2019 г.

How do you password protect a file?

Protect a document with a password

1. Go to File > Info > Protect Document > Encrypt with Password.
2. Type a password, then type it again to confirm it.
3. Save the file to make sure the password takes effect.

How do I unlock a password protected Excel file for free?

Instructions

1. Click “Browse…” and select the . XLS or . XLSX file you would like to unprotect.
2. Agree to the Terms of Service by checking the appropriate check box.
3. Click “Unlock File!” – and you’re done!

How do I remove encryption in Excel without password?

Method 1. Decrypt Excel File without Password Using VBA Code

1. Create a new MS Excel file. Press ALT+F11 simultaneously to open the VBA window.
2. Select Insert and click on Module.
3. Press the F5 key, or rather, click on Run to run the code.
4. Upon popping up of a small box, click on OK.
5. Close the VBA window.

How do I remove a password from an Excel 2013 file?

How to Remove Password from Excel Spreadsheet

1. Open your spreadsheet and enter the password.
2. Click File.
3. Click Protect Workbook, then Encrypt with Password.
4. Delete the password, then click OK.
5. Save the workbook.

7 дней назад