1. Excel鎖定窗口怎麼弄啊
假設你要凍結第一行,則滑鼠選擇A2格,窗口---凍結窗格
假設你要凍結第一行和第一列,則滑鼠選擇B2格,窗口---凍結窗格
2. Excel 如何鎖定按鈕不讓修改
excel鎖定單元格的步驟
1
打開excel表格,對需要鎖定的部分單元格進行全選,然後點擊滑鼠右鍵,在彈出來的設置功能中,選擇「設置單元格格式」。(如下圖)
3. 在excel表格里怎樣鎖定整個表格
全選表格所有、鎖定,再保護工作表就可以。
再遇問題請拷屏追問。
4. excel表格設置鎖定不可修改
實現方法:首先打開需要進行操作的excel表格,點擊頁面頂部的「審閱」-「保護工作表」選項;然後在彈出的「保護工作表」對話框里輸入設定的密碼,點擊下方「確定」;最後彈出的「確認」對話框里再次輸入設密碼,點擊下方「確定」即可。
5. 如何在excel中設置單元格鎖定與解鎖
方法一:
1.首先,利用Excel快捷鍵"Ctrl + A"全選所以的單元格,然後,右鍵選擇「設置單元格格式」。
2.在彈出的「單元格格式」中選擇「保護」,取消「鎖定」前面的鉤去掉。
方法二:
1.打開文件。
2.工具---宏----錄制新宏---輸入名字,如「aa」。
3.停止錄制(這樣得到一個空宏)。
4.工具---宏----宏,選「aa」,點編輯按鈕。
5.刪除窗口中的所有字元,替換為下面的內容:
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 'mmy 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 Sub
6.關閉編輯窗口。
7.工具---宏-----宏,選AllInternalPasswords,運行,確定兩次,等2分鍾,再確定即可完成操作。
6. 筆記本電腦上的excel編輯鎖定怎麼解除,它的下面全是灰色的,右擊鍵沒有復制粘
看看是否激活了?如果是激活狀態,說明程序有問題,插入office光碟修復安裝一下就可以了。
7. 電腦中excel鎖定單個單元格的方法 excel如何鎖定單元格的步驟
電腦中excel鎖定單個單元格的方法
excel如何鎖定單元格的步驟。電腦中的excel表格是很多人常用的應用之一,因為這是在電腦中具有實用性的辦公應用,使用的人非常的多。那麼在表格中,我們應該怎麼鎖定單元格呢?一起來看看吧。
這里我所說的「鎖定單元格」含義是指將某塊區域的一些單元格保護起來,保護後是無法進行編輯與修改的,只有通過輸入先前設置的密碼正確後才可以重新開始編輯和修改!具體操作如下:
鎖定單個或多個單元格方法
①首先,利用Excel快捷鍵
Ctrl
+
A
全選所以的單元格,然後,右鍵選擇「設置單元格格式」;
②在彈出的「單元格格式」中選擇「保護」,取消「鎖定」前面的鉤去掉;
③選中你所想要鎖定的單個或多個單元格,再次右鍵選擇「設置單元格格式」;
④同樣,在彈出的「單元格格式」窗口中選擇「保護」,再將「鎖定」前面的鉤打上,確定;
⑤繼續選中需要鎖定的單元格,然後單擊菜單欄的「工具」-->保護-->保護工作表,在彈出的「保護工作表」窗口中我們輸入鎖定該單元格的密碼(千萬別把密碼忘記了喲);
到這里鎖定單元格就已經設置完畢了!現在你可以回到Excel表格中看看,剛才被我們鎖定的單元格貌似不可以編輯和修改了,每次編輯它都會提示:「正在視圖更改被保護的只讀單元格或圖標」。
如果想重新對鎖定的單元格進行編輯或修改,單擊菜單欄的「工具」中的「保護」下的「撤銷工作表保護」,在窗口中重新輸入設置的密碼,即可撤銷工作表的鎖定。
對於我們遇到了這樣的設置不知道怎麼操作的時候,完全可以利用到上面文中給你們介紹的解決方法進行處理,相信一定可以幫助到你們的。
8. 如何excel文檔鎖定,打開副本
有兩個辦法
1,防止他人負責文件,可以選用鎖定的方式,方法是:
點擊菜單→工具(下拉菜單)→保護→保護工作表
這時候會有窗口彈出,在選項中打勾選擇,然後輸入密碼。確定
確定後,文檔無法編輯或復制,除非輸入密碼
2,採用只讀密碼
方法是
文件選擇
另存為→彈出對話框→選擇右上角的「工具」→在下拉菜單中選擇「常規選項」,然後在彈出對話框中輸入密碼。
注意有兩個密碼,一個是打開密碼,如果設置了打開密碼後,沒有密碼是無法打開文件的,另外一個是「修改許可權密碼」,設置了該密碼後,文檔如果沒有密碼就只能夠用「只讀」的方法打開了。
上述兩種鎖定方式都有應用,看你的需求
9. Excel表下的功能欄如何鎖定
1、我們打開一個excel表格,發現excel表格因為誤操作缺少工具欄。
(9)筆記本excel鎖定在哪裡設置方法擴展閱讀
Excel雖然提供了大量的用戶界面特性,但它仍然保留了第一款電子製表軟體VisiCalc的特性:行、列組成單元格,數據、與數據相關的公式或者對其他單元格的絕對引用保存在單元格中。
Excel是第一款允許用戶自定義界面的電子製表軟體(包括字體、文字屬性和單元格格式)。它還引進了「智能重算」的功能,當單元格數據變動時,只有與之相關的數據才會更新,而原先的製表軟體只能重算全部數據或者等待下一個指令。
1993年Excel第一次被捆綁進Microsoft Office中時,Microsoft就對Microsoft Word和PowerPoint的界面進行了重新設計,以適應這款當時極為流行的應用程序。
從1993年,Excel就開始支持Visual Basic for Applications(VBA).VBA是一款功能強大的工具,它使Excel形成了獨立的編程環境。
使用VBA和宏,可以把手工步驟自動化,VBA也允許創建窗體來獲得用戶輸入的信息。但是,VBA的自動化功能也導致Excel成為宏病毒的攻擊目標。
參考資料來源:網路-Microsoft Office Excel