Excel鎖定一個單元格不能滾動的百具體解決方法如下：我們需要準(zhǔn)備的材料分別是：度電腦、Excel表格。1、首先我們打開需要編輯的Excel表格。2、然后我們在專彈出來的窗口中點擊打開視屬圖中的“凍結(jié)窗格”下面的小倒三角形。3、然后我們在彈出來的窗口中點擊“取消凍結(jié)窗格”即可，1、如圖以最常見的成績單為例，數(shù)據(jù)較多，希望往下查百看數(shù)據(jù)時，第一行表頭和第一列姓名保持不變。度2、  單擊需要固定的位置下放第一個有數(shù)據(jù)的單元格。仔細觀察問圖中所選的是B2，然后點數(shù)據(jù)菜單中的凍結(jié)窗口。答3、 會看到屏幕上版多出了兩條細實線。箭頭所指。這就是鎖定的標(biāo)志。4、試試查看下發(fā)的別的數(shù)據(jù)會看到。第權(quán)一行第一列會除于鎖定狀態(tài)顯示。注意事項：需要取消鎖定的話，還是點數(shù)據(jù)菜單中。如圖，點擊取消凍結(jié)窗口。本回答被網(wǎng)友采納，這個應(yīng)該是被凍結(jié)了，你可以在視圖-凍結(jié)窗格-取消凍結(jié)拆分窗格 這樣就應(yīng)該就可以了www.tz-yilong.com防采集。

Excel鎖定單元格 怎樣取消鎖定單元格呢？

方法

打開excel表，對excel表進行全選，全選表格有兩種方法。方法一：點擊表格最中上方的位置（圖示位置）；方法二：用Ctrl+A對表格進行全選。全選表格后點擊鼠標(biāo)右鍵，在列表中選擇【設(shè)置單元格格式】。

按照如下步驟即可在excel中鎖定單元格公式不被修改：1、首先打開excel表格，在單元格中插入一

進入單元格格式設(shè)置頁面后，在最上方的選項卡中選擇【保護】，然后將下方【鎖定】選項前面的勾選去掉，接著點擊設(shè)置頁面下方的【確定】按鈕。

1、打開Excel表格2019版本，然后選中要鎖定的單元格。2、選中單元格之后，按Ctrl+1調(diào)

選中要鎖定的單元格（要鎖定的單元格可以是列，也可以是行，還可以是單個單元格），然后點擊鼠標(biāo)右鍵，在列表中選擇【設(shè)置單元格格式】。

下面那個人回答了，說的有點啰嗦，我就簡單直白的給你說如何鎖定單元格不被修改昂1、把表中所有的表格全

在選項卡中選擇【保護】，然后勾選【鎖定】，接著點擊【確定】。

工具：Office2013方法如下：選擇要解除鎖定的單元格，點擊右鍵，選擇“設(shè)置單元格格式”：

在excel表的菜單欄中選擇【審閱】，然后在其下方的工具欄中點擊選擇【保護工作表】。

1、首先在電腦桌面，打開自己需要鎖定表頭的excel表格。2、打開excel表格之后，需要鎖定的

在彈出來的保護工作表頁面中輸入保護密碼，然后在下方的列表中勾選“選定鎖定單元格”和“選定未鎖定的單元格”兩個選項，接著點擊窗口下方的【確定】選項，如圖所示。

Excel鎖定一個單元格不能滾動的具體解決方法如下：我們需要準(zhǔn)備的材料分別是：電腦、Excel表格

在“確認密碼”的頁面中再次輸入保護密碼，本次輸入的保護密碼應(yīng)與第一次輸入的一致，輸入完成后點擊【確定】。

Excel中鎖定單元格要如何解鎖呢？大家一定也遇到過這樣的問題，今天就來教大家如何解鎖被鎖定的單元格

下面來看一下設(shè)置設(shè)置效果，用鼠標(biāo)點擊進行保護了的單元格，excel表格就會彈出如圖所示的信息，說明設(shè)置成功。

1、演示使用的軟件為Excel電子表格，軟件版本為office家庭和學(xué)生版2016。2、首先打開

方法一：1.首先，利用Excel快捷鍵"Ctrl + A"全選所以的單元格，然后，右鍵選擇“設(shè)置單元格格式”。2.在彈出的“單元格格式”中選擇“保護”，取消“鎖定”前面的鉤去掉。方法二：1.打開文件。2.工具e799bee5baa6e79fa5e98193e78988e69d8331333431376635---宏----錄制新宏---輸入名字，如“aa”。3.停止錄制(這樣得到一個空宏)。4.工具---宏----宏,選“aa”,點編輯按鈕。5.刪除窗口中的所有字符,替換為下面的內(nèi)容:Option ExplicitPublic Sub AllInternalPasswords()' Breaks worksheet and workbook structure passwords. Bob McCormick' probably originator of base code algorithm modified for coverage' of workbook structure / windows passwords and for multiple passwords'' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)' Modified 2003-Apr-04 by JEM: All msgs to constants, and' eliminate one Exit Sub (Version 1.1.1)' Reveals hashed passwords NOT original passwordsConst DBLSPACE As String = vbNewLine & vbNewLineConst AUTHORS As String = DBLSPACE & vbNewLine & _"Adapted from Bob McCormick base code by" & _"Norman Harker and JE McGimpsey"Const HEADER As String = "AllInternalPasswords User Message"Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"Const REPBACK As String = DBLSPACE & "Please report failure " & _"to the microsoft.public.excel.programming newsgroup."Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _"now be free of all password protection, so make sure you:" & _DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _DBLSPACE & "Also, remember that the password was " & _"put there for a reason. Don't stuff up crucial formulas " & _"or data." & DBLSPACE & "Access and use of some data " & _"may be an offense. If in doubt, don't."Const MSGNOPWORDS1 As String = "There were no passwords on " & _"sheets, or workbook structure or windows." & AUTHORS & VERSIONConst MSGNOPWORDS2 As String = "There was no protection to " & _"workbook structure or windows." & DBLSPACE & _"Proceeding to unprotect sheets." & AUTHORS & VERSIONConst MSGTAKETIME As String = "After pressing OK button this " & _"will take some time." & DBLSPACE & "Amount of time " & _"depends on how many different passwords, the " & _"passwords, and your computer's specification." & DBLSPACE & _"Just be patient! Make me a coffee!" & AUTHORS & VERSIONConst MSGPWORDFOUND1 As String = "You had a Worksheet " & _"Structure or Windows Password set." & DBLSPACE & _"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _"Note it down for potential future use in other workbooks by " & _"the same person who set this password." & DBLSPACE & _"Now to check and clear other passwords." & AUTHORS & VERSIONConst MSGPWORDFOUND2 As String = "You had a Worksheet " & _"password set." & DBLSPACE & "The password found was: " & _DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _"future use in other workbooks by same person who " & _"set this password." & DBLSPACE & "Now to check and clear " & _"other passwords." & AUTHORS & VERSIONConst MSGONLYONE As String = "Only structure / windows " & _"protected with the password that was just found." & _ALLCLEAR & AUTHORS & VERSION & REPBACKDim w1 As Worksheet, w2 As WorksheetDim i As Integer, j As Integer, k As Integer, l As IntegerDim m As Integer, n As Integer, i1 As Integer, i2 As IntegerDim i3 As Integer, i4 As Integer, i5 As Integer, i6 As IntegerDim PWord1 As StringDim ShTag As Boolean, WinTag As BooleanApplication.ScreenUpdating = FalseWith ActiveWorkbookWinTag = .ProtectStructure Or .ProtectWindowsEnd WithShTag = FalseFor Each w1 In WorksheetsShTag = ShTag Or w1.ProtectContentsNext w1If Not ShTag And Not WinTag ThenMsgBox MSGNOPWORDS1, vbInformation, HEADERExit SubEnd IfMsgBox MSGTAKETIME, vbInformation, HEADERIf Not WinTag ThenMsgBox MSGNOPWORDS2, vbInformation, HEADERElseOn Error Resume NextDo 'dummy do loopFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126With ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & _Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)If .ProtectStructure = False And _.ProtectWindows = False ThenPWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)MsgBox Application.Substitute(MSGPWORDFOUND1, _"$$", PWord1), vbInformation, HEADERExit Do 'Bypass all for...nextsEnd IfEnd WithNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextLoop Until TrueOn Error GoTo 0End IfIf WinTag And Not ShTag ThenMsgBox MSGONLYONE, vbInformation, HEADERExit SubEnd IfOn Error Resume NextFor Each w1 In Worksheets'Attempt clearance with PWord1w1.Unprotect PWord1Next w1On Error GoTo 0ShTag = FalseFor Each w1 In Worksheets'Checks for all clear ShTag triggered to 1 if not.ShTag = ShTag Or w1.ProtectContentsNext w1If ShTag ThenFor Each w1 In WorksheetsWith w1If .ProtectContents ThenOn Error Resume NextDo 'Dummy do loopFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126.Unprotect Chr(i) & Chr(j) & Chr(k) & _Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)If Not .ProtectContents ThenPWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)MsgBox Application.Substitute(MSGPWORDFOUND2, _"$$", PWord1), vbInformation, HEADER'leverage finding Pword by trying on other sheetsFor Each w2 In Worksheetsw2.Unprotect PWord1Next w2Exit Do 'Bypass all for...nextsEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextLoop Until TrueOn Error GoTo 0End IfEnd WithNext w1End IfMsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADEREnd Sub6.關(guān)閉編輯窗口。7.工具---宏-----宏,選AllInternalPasswords,運行,確定兩次,等2分鐘,再確定即可完成操作，方法一：1.首先，利用Excel快捷鍵"Ctrl + A"全選所以的單元格，然后，右鍵選擇“設(shè)置單元格格式”。2.在彈出的“單元格格式”中選擇“保護”，取消“鎖定”前面的鉤去掉。方法二：1.打開文件。2.工具---宏----錄制新宏---輸入名字，如“aa”。3.停止錄制(這樣得到一個空宏)。4.工具---宏----宏,選“aa”,點編輯按鈕。5.刪除窗口中的所有字符,替換為下面的內(nèi)容: Option Explicit Public Sub AllInternalPasswords() ' Breaks worksheet and workbook structure passwords. Bob McCormick ' probably originator of base code algorithm modified for coverage ' of workbook structure / windows passwords and for multiple passwords ' ' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) ' Modified 2003-Apr-04 by JEM: All msgs to constants, and ' eliminate one Exit Sub (Version 1.1.1) ' Reveals hashed passwords NOT original passwords Const DBLSPACE As String = vbNewLine & vbNewLine Const AUTHORS As String = DBLSPACE & vbNewLine & _ "Adapted from Bob McCormick base code by" & _ "Norman Harker and JE McGimpsey" Const HEADER As String = "AllInternalPasswords User Message" Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04" Const REPBACK As String = DBLSPACE & "Please report failure " & _ "to the microsoft.public.excel.programming newsgroup." Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _ "now be free of all password protection, so make sure you:" & _ DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _ DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _ DBLSPACE & "Also, remember that the password was " & _ "put there for a reason. Don't stuff up crucial formulas " & _ "or data." & DBLSPACE & "Access and use of some data " & _ "may be an offense. If in doubt, don't." Const MSGNOPWORDS1 As String = "There were no passwords on " & _ "sheets, or workbook structure or windows." & AUTHORS & VERSION Const MSGNOPWORDS2 As String = "There was no protection to " & _ "workbook structure or windows." & DBLSPACE & _ "Proceeding to unprotect sheets." & AUTHORS & VERSION Const MSGTAKETIME As String = "After pressing OK button this " & _ "will take some time." & DBLSPACE & "Amount of time " & _ "depends on how many different passwords, the " & _ "passwords, and your computer's specification." & DBLSPACE & _ "Just be patient! Make me a coffee!" & AUTHORS & VERSION Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _ "Structure or Windows Password set." & DBLSPACE & _ "The password found was: " & DBLSPACE & "$$" & DBLSPACE & _ "Note it down for potential future use in other workbooks by " & _ "the same person who set this password." & DBLSPACE & _ "Now to check and clear other passwords." & AUTHORS & VERSION Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _ "password set." & DBLSPACE & "The password found was: " & _ DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _ "future use in other workbooks by same person who " & _ "set this password." & DBLSPACE & "Now to check and clear " & _ "other passwords." & AUTHORS & VERSION Const MSGONLYONE As String = "Only structure / windows " & _ "protected with the password that was just found." & _ ALLCLEAR & AUTHORS & VERSION & REPBACK Dim w1 As Worksheet, w2 As Worksheet Dim i As Integer, j As Integer, k As Integer, l As Integer Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer Dim PWord1 As String Dim ShTag As Boolean, WinTag As Boolean Application.ScreenUpdating = False With ActiveWorkbook WinTag = .ProtectStructure Or .ProtectWindows End With ShTag = False For Each w1 In Worksheets ShTag = ShTag Or w1.ProtectContents Next w1 If Not ShTag And Not WinTag Then MsgBox MSGNOPWORDS1, vbInformation, HEADER Exit Sub End If MsgBox MSGTAKETIME, vbInformation, HEADER If Not WinTag Then MsgBox MSGNOPWORDS2, vbInformation, HEADER Else On Error Resume Next Do 'dummy do loop For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 With ActiveWorkbook .Unprotect Chr(i) & Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If .ProtectStructure = False And _ .ProtectWindows = False Then PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) MsgBox Application.Substitute(MSGPWORDFOUND1, _ "$$", PWord1), vbInformation, HEADER Exit Do 'Bypass all for...nexts End If End With Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next Loop Until True On Error GoTo 0 End If If WinTag And Not ShTag Then MsgBox MSGONLYONE, vbInformation, HEADER Exit Sub End If On Error Resume Next For Each w1 In Worksheets 'Attempt clearance with PWord1 w1.Unprotect PWord1 Next w1 On Error GoTo 0 ShTag = False For Each w1 In Worksheets 'Checks for all clear ShTag triggered to 1 if not. ShTag = ShTag Or w1.ProtectContents Next w1 If ShTag Then For Each w1 In Worksheets With w1 If .ProtectContents Then On Error Resume Next Do 'Dummy do loop For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 .Unprotect Chr(i) & Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If Not .ProtectContents Then PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _ Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) MsgBox Application.Substitute(MSGPWORDFOUND2, _ "$$", PWord1), vbInformation, HEADER 'leverage finding Pword by trying on other sheets For Each w2 In Worksheets w2.Unprotect PWord1 Next w2 Exit Do 'Bypass all for...nexts End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next Loop Until True On Error GoTo 0 End If End With Next w1 End If MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER End Sub6.關(guān)閉編輯窗口。7.工具---宏-----宏,選AllInternalPasswords,運行,確定636f7079e799bee5baa6e997aee7ad9431333337613764兩次,等2分鐘,再確定即可完成操作。本回答被網(wǎng)友采納，工具：zhidaoOffice2013方法如下：選擇要解除鎖定的單元格，點擊右鍵，選擇“設(shè)置單元格格式”：在保護選項卡中，找到并取消勾選“鎖定”：確定之后，選擇的單元格就被內(nèi)解決了鎖定，像保護工作表之類的就不會再作用于這些容解除鎖定的單元格上。本回答被網(wǎng)友采納，1、首先打開Excel表格，此時單元格被鎖定，如果需要修改單元格里面的內(nèi)容zd，會彈出如下窗口，無法修改。回2、然后在工具欄里面點擊審閱這個選項。3、接著找到撤銷工作表保護這個選項，答并點擊此選項。4、點擊了之后，輸入撤銷工作表保護的密碼，點擊確定即可， 這樣就可以解鎖了。本回答被網(wǎng)友采納，1、演示zhidao使用的軟件為Excel電子表格，軟件版本為office家庭和學(xué)生版2016。2、首先打開Excel電子表格，并在表格中輸入用于演示鎖定部分單元格的數(shù)據(jù)。3、首先選中所有數(shù)據(jù)區(qū)域，單擊鼠標(biāo)右鍵選擇設(shè)置，單元格是在單元格格式設(shè)置窗口中，選擇保護選項，并取版消鎖定和隱藏的勾選，點擊確定。4、此時選中想要進行鎖定不被修改的單元格，再次打開設(shè)置單元格格式，并勾選鎖定和隱藏的保護菜單。5、找到工具欄中的審閱菜單，在審閱菜單下找到保護工作表選項，點擊后設(shè)置保護密碼。6、此時點擊我權(quán)們鎖定的單元格內(nèi)容進行修改，可以看到當(dāng)前單元格已經(jīng)處于保護狀態(tài)了，對Excel單元格的保護，可以分以下幾個方面進行。 1. “隱藏”并“鎖定”每張工作表含有“公式”zhidao的單元格 這樣可以讓錄入人員僅看到各“公式”的運算結(jié)果，無法看到“公式”的真正內(nèi)容，并且對這些單元格也無法進行編輯操作，以保證公式的安全及計算結(jié)果的可信度。 首先選中這些單元格，依次點擊“格式→單元格”（或從右鍵菜單中選擇“設(shè)置單元格格式”命令），打開一個對話框，選中其中的“隱藏”和“鎖定”項即可。 2.“鎖定”除科目成績外的所有單版元格 這樣可以讓錄入人員僅能錄入相關(guān)科目的成績，不能“插入”或“刪除”行、列，不能改變其他單元格的內(nèi)容，也不能設(shè)置單元格的格式（保證打印格式的統(tǒng)一）。 Excel在默認情況下，對工作表中的所有單元格都設(shè)為“鎖定權(quán)”狀態(tài)。為了在錄入人員錄入后可以進行相關(guān)操作，就要解除這些單元格的“鎖定”。具體方法是取消對“鎖定”項的選擇即可。 另外，需要說明的是，要使單元格的“隱藏”和“鎖定”真正生效，必須依次點擊“工具→保護→保護工作表”。打開一個對話框，在其中設(shè)置“保護密碼”和其他設(shè)置。本回答被提問者采納，1. 全選工作表，單元格格式，保護，取消鎖定2. 選擇你的范圍，勾選鎖定3. 保護工作表，這個首先要選定單元格，然后右鍵單擊單元格的設(shè)置進去之后就有鎖定的部分內(nèi)容來自www.tz-yilong.com請勿采集。

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com