Cara Membuka Password File Excel 2010 By default, the new copy of the file has the same name as the original with a "~" (tilde) added to the end. 4.Delete the original file. In Finder or the Windows File Explorer, right-click and choose Delete. However, if you open the file, you will be prompted to replace the. 5.Double-click the Excel file that contains the sheet that you want to unprotect. 6.See if the Excel file is protected. Right-click the Excel file and choose Properties. 7.Copy the password to the clipboard. Press Ctrl + Shift + C 8.Enter the password into the Password box. 9.Choose the option you want. If you want to open the file to change anything in it (Excel 2007), you will need to change the Excel file with the sheet you want to protect. Cara Membuka Password File Excel 2007 Open the Excel file in which you want to change the sheet. Choose File > Info > . 10.From the left, choose Encrypt and Protect > Protect Document > New Password > Check to see if the file is password-protected and enter the password. 11.Enter the password and then click OK to protect the document. Select the sheet with the information you want to change in the document. Choose Edit > Copy > Paste. In the new Excel file, replace the original sheet with the sheet you want to protect. 12.Select the sheet that you want to change. Choose Edit > Paste > Cells. Enter the password and click OK to protect the Excel file. Unlock Excel spreadsheet with VBA code (for Excel 2007 or later) If you are using Microsoft Excel 2007 or later, you can unlock a password-protected sheet . 13.Copy the coding used in this method in step 14 14.Open the document and enter its password. 15.Click the Excel file and choose File > Info > Protect Document > Encrypt with Password. 16.Click the Password box to enter the password. 17.Click OK to protect the document. 18.Select the sheet you want to unlock. 19.Click the drop-down menu for Protection, then choose Unprotect Sheet, Manually. 20.Select the cells you want to protect, enter the password, and click OK. Cara Membuka Password File Excel 2003 To open a protected file in Excel 2003, press 2.Choose File > Info > Protect Document > Encrypt with Password. Browse for the file that contains the password. Keep the default password and click OK. 4.Click OK to return to the previous window. 5.Use Find on the File menu to open the password field. 6.If you have created your own document-level password, enter it and press Enter. 7.Click OK to return to the previous window. 8.Click Show Password to open the workbook, or click OK to close the workbook. 9.When asked for a password, enter the password and press Enter. Unprotect the password-protected sheet. 10.Click Save to save the file in the normal location. Best regards, Inside Application: (before Office for Mac 2010) Excel for Macintosh 1.Open a file. 2.Click File > Info. 3.Click Protect Document. 4.Click Encrypt with Password. 5.In the Password dialog box, enter a new password. Select the sheet to which you want to apply the new password. Excel Mac 2010: 1.Open a file. 2.Click File > Info. 3.Click Protect Document. 4.Click Encrypt with Password. 5.Click Clear Password. 6.In the Password dialog box, enter a new password. 7.Click OK. Excel for Mac 2011: 1.Open a file. 2.Click File > Info. 3.Click Protect Document. 4.Click Encrypt with Password. 5.Click Clear Password. 6.Click OK. Excel for Mac 2013: 1.Open a file. 2.Click File > Info. 3.Click Protect Document. 4.Click Encrypt with Password. 5.Click Clear Password. 6.Click OK. Excel for Mac 2016: 1.Open a file. 2.Click File > Info. 3.Click Protect Document. 4.Click Encrypt with Password. 5.Click Clear Password. 6.Click OK. Excel Mac Excel 2010 1.Open a file. 2.Click File > Info. 3.Click Protect Document. 4.Click Encrypt with Password. 5.Click Clear Password. 6.Click OK. If you have the Office 2013 ProPlus application installed, you can click Tools > Protect workbook. Excel for Mac Excel 2013: 1.Open a file. 2.Click File > Info. 3. 55cdc1ed1c
Related links: