excel set a password how to unlock
excel sheet under the review page click on undo worksheet protection, enter the password.
Tools: Dell K550, Win11, excel sheet 2002 version.
1, first of all, in the excel sheet click review, as shown in the following figure.
2, and then under the review option click on the revocation of worksheet protection, as shown in the following figure.
3, and then in the window that opens, enter the set protection password, as shown in the following figure.
4, and finally in the form of the password can be canceled, as shown in the figure below is complete.
Excel’s office skills
1, do not copy the hidden rows: select the hidden or filtered areas, the shortcut Alt +; Copy and Paste.
2, the production of drop-down menus: Select the target cell area, click [Data] menu [Data Tools] group in the [Data Validation], open the [Data Validation] dialog box. Select [Allow] in the [Sequence], click the arrow to the right of the [Source] text box to select the B3: B12 region and [OK].
3, cell line feed: the cursor will be inserted into the need to change the display of the characters before the shortcut Alt + Enter can be.
4, delete duplicate values: Select the target cell area, click [Data] menu [Data Tools] group [Delete Duplicate Values], open the [Delete Duplicate Item Warning] dialog box. Check [to the currently selected area or sorting] and [remove duplicates], open the [Remove Duplicate Values] dialog box, click [OK] – [OK] can be.
Locked cells how to unlock?
Locked cells how to unlock?
Question 1: Excel is locked in the cell how to unlock the 10-point method:
1. First of all, the use of Excel shortcuts Ctrl + A selected so the cell, and then, right-click and select “Set Cell Format”.
2. In the pop-up “cell format” in the “protection”, cancel the “lock” in front of the hook removed.
Method 2:
1. Open the file.
2. Tools — Macro —- record a new macro — enter a name, such as “aa”.
3. Stop recording (so you get an empty macro).
4. Tools — Macro —- macro, select “aa”, click the Edit button.
5. Delete all the characters in the window, replaced by the following:
OptionExplicit
PublicSubAllInternalPasswords()
” Breaksworksheetandworkbookstructurepasswords.BobMcCormick
‘probablyoriginatorofbasecodealgorithmmodifiedforcoverage
‘ ofworkbookstructure/windowspasswordsandformultiplepasswords
‘
‘NormanHarkerandJEMcGimpsey27-Dec-2002(Version1.1)
‘Modified2003-Apr-04byJEM:Allmsgstoconstants,and
‘eliminateoneExitSub(Version1.1.1)
‘ RevealshashedpasswordsNOToriginalpasswords
ConstDBLSPACEAsString=vbNewLine&vbNewLine
ConstAUTHORSAsString=DBLSPACE &vbNewLine&_
AdaptedfromBobMcCormickbasecodeby&_
NormanHarkerandJEMcGimpsey
ConstHEADERAsString= AllInternalPasswordsUserMessage
ConstVERSIONAsString=DBLSPACE&Version1.1.12003-Apr-04
ConstREPBACKAsString= DBLSPACE&Pleasereportfailure&_
tothemicrosoft.public.excel.programmingnewsgroup.
ConstALLCLEARAsString= DBLSPACE&Theworkbookshould&_
nowbefreeofallpasswordprotection,somakesureyou:&_
DBLSPACE&SAVEITNOW!& ;DBLSPACE&&q…… >>
Question 2: wps lock cell how to lift the cancel worksheet protection can be made to lock the cell is invalid. At this point you can go one step further, right-click on the locked cells, select “Cell Format | Protect”, the “lock” before the check box to uncheck the state. After this operation, even after setting up a “protection worksheet”, and the cell will not be locked.
Question 3: How to unlock the form lock 1. Select the entire form, point formatting – & gt; cell – & gt; protection, cancel the lock in front of the check mark, point OK.
2. Select the entire form, point Tools – & gt; Protection – & gt; Undo worksheet protection, point OK.
I don’t know if it can help you!
Please take the answer and support me a little.
Question 4: excel table locked without a password how to unlock 1, select the worksheet – right – set the cell format – protection, the “lock” before the check mark, OK. (All regions are valid)
2, select the cells do not need to lock, right-click – set the cell format format – protection, cancel the “lock” before the hook, OK. (Individual regions are valid, you can edit, modify and other operations)
3, point single menu bar – Tools – Protection – Protection Worksheet, enter the protection password, OK. (No protection password, can not modify or edit the operation)
Question 5: If you unlock excel locked cells 1, remove the worksheet protection
2, select the need to unlock the region
3, right-click – Set Cells for -protection, remove the check before the lock can be
Question 6: excel table is locked how to unlock – tools – protection – – cancel the protection
Question 7: excel how to unlock the cell method 1:
1. First of all, the use of Excel shortcut Ctrl + A select all the cells, and then, right-click and select “Set Cell Format”.
2. In the pop-up “cell format” in the “protection”, cancel the “lock” in front of the hook removed.
Method 2:
1. Open the file.
2. Tools — Macro —- record a new macro — enter a name, such as “aa”.
3. Stop recording (so you get an empty macro).
4. Tools — Macro —- macro, select “aa”, click the Edit button.
5. Delete all the characters in the window, replaced by the following:
OptionExplicit
PublicSubAllInternalPasswords()
” Breaksworksheetandworkbookstructurepasswords.BobMcCormick
‘probablyoriginatorofbasecodealgorithmmodifiedforcoverage
‘ ofworkbookstructure/windowspasswordsandformultiplepasswords
‘
‘NormanHarkerandJEMcGimpsey27-Dec-2002(Version1.1)
‘Modified2003-Apr-04byJEM:Allmsgstoconstants,and
‘eliminateoneExitSub(Version1.1.1)
‘ RevealshashedpasswordsNOToriginalpasswords
ConstDBLSPACEAsString=vbNewLine&vbNewLine
ConstAUTHORSAsString=DBLSPACE &vbNewLine&_
AdaptedfromBobMcCormickbasecodeby&_
NormanHarkerandJEMcGimpsey
ConstHEADERAsString= AllInternalPasswordsUserMessage
ConstVERSIONAsString=DBLSPACE&Version1.1.12003-Apr-04
ConstREPBACKAsString= DBLSPACE&Pleasereportfailure&_
tothemicrosoft.public.excel.programmingnewsgroup.
ConstALLCLEARAsString= DBLSPACE&Theworkbookshould&_
nowbefreeofallpasswordprotection,somakesureyou:&_
DBLSPACE&SAVEITNOW!& ;DBLSPACE&&q…… >>
Question 8: How to unlock the spreadsheet is locked → Set cell formatting → protection → remove the “lock” in the box before the √ → OK (this step is to set up the protection of other cells can be edited)
2, select the formula to be protected where the cell ¡ú repeat the process ¡ú in the “lock” before the box with a “√”; (this step is to set up the protection of the formula where the cell)
3, Tools ¡ú Protection ¡ú Protection Worksheet ¡ú set the password (twice, you can also not set) ¡ú OK.
Note: need to modify the formula → Tools → Protection → Undo worksheet protection
Question 9: excel formatting is locked how to lift? Click on “remove worksheet protection” can be unlocked.
The location of the button is shown in the figure below:
Question 10: The excel cell is locked, no password. How to unlock. Password unlocker is useless. Seek method. Step 1: 1, open the file, the first to lift the default “macro disabled” state. Method: Click the toolbar under the “Options” status button, open the “Microsoft Office Security Options” window, select the “Enable this content”, “OK”. Select “Enable this content” and “OK” to exit.” (or: Security ¡ú Macro Security ¡ú Very High, and then click OK, OK) 2, click again on the “Macro” ¡ú “Record Macro”, there is a “Record New Macro” window, in the “Macro Name” to define a name: PasswordBreaker, click “OK” to exit. Step 2: 1, and then click “Macro” ¡ú “View Macro”, select “Macro Name” under the “PasswordBreaker “and click “Edit”, open the “MicrosoftVisualBasic” editor, clear all the contents of the editor, copy the following code to the right side of the editor window bar: i2AsInteger,i3AsInteger
Dimi4AsInteger,i5AsInteger,i6AsInteger
OnErrorResumeNext
Fori=65To66:Forj=65To66:Fork= 65To66
Forl=65To66:Form=65To66:Fori1=65To66
Fori2=65To66:Fori3=65To66:Fori4=65To66
Fori5=65To66:Fori6=65To66. Forn=32To126
ActiveSheet.UnprotectChr(i)&Chr(j)&Chr(k)&_
Chr(l)&Chr(m)&Chr(i1)&Chr(i2)&Chr (i3)&_
Chr(i4)&Chr(i5)&Chr(i6)&Chr(n)
IfActiveSheet.ProtectContents=FalseThen
MsgBoxOneusablepasswordis&Chr(i)&Chr(j)&_
Chr(k)&Chr(l)&Chr(m)&Chr(i1)&Chr(i2)&_
Chr( i3)&Chr(i4)&Chr(i5)&Chr(i6)&Chr(n)
ActiveWorkbook.Sheets(1).Select
Range(a1).FormulaR1C1=Chr(i)& Chr(j)&_
Chr(k)&Chr(l)&Chr(m)&Chr(i1)&Chr(i2)&_
Chr(i3)&Chr(i4)&Chr(i5)&Chr(i6)& amp;Chr(n)
ExitSub
EndIf
Next:Next:Next:Next:Next:Next:Next:Next
Next:Next:Next:Next:Next:Next:Next
EndSub Step 3: 1. Click again on “Macro” → “View Macro”, select “Macro Name” under the “PasswordBreaker ” and click “Run”, the password is present, at the same time, your document will eliminate the protection….. >>
excel2010 how to protect cells
In the use of Excel2010 will want to lock some cells, in order to prevent others from tampering with or mistakenly deleted data. That this how to operate it? Specific steps please see the following:
Methods/Steps
Open Excel2010, select any cell, right mouse button, open the menu select “Set Cell Format” command
Switch to the “Protect” tab. ” tab, where we can see the default “Lock” check box is checked, that is, once the lock of the worksheet, all the cells are also locked.
Press Ctrl + A shortcut key to select all the cells, and then right-click on the “Set Cell Format”, switch to the “Protect” tab, the “lock “Review” tab, in the “Change” group, click the “Protect Sheet” button
Pop-up “Protect Sheet locked cell, the following dialog box will appear
If you want to unlock, then switch to the “Review” tab, in the “Changes” group, click the “Undo worksheet protection “button in the Changes group