EXCEL如何锁定单元格（锁定的单元格不能修改）表设计完成之后，首先右键点选右上角的空白处，实现表格全眩在右键快捷菜单中选择“设置单元格格式”，在打开的界面中选择“保护”，将里面的“锁定”勾选项去掉并保存。然后，选择需要保护的单元格区域，

如果要对工作表中的某个或某些单元格的格式锁定，不想让别人进行修改，则要进行单元格格式的锁定操作，下面介绍一下方法。

材料/工具

Excel

方法

想对单元格中的“21”单元格格式进行锁定，则要先选定单元格，然后单击右键选择“设置单元格格式”，点击后会出现选择窗口。

Excel中锁定单元格要如何解锁呢？大家一定也遇到过这样的问题，今天就来教大家如何解锁被锁定的单元格。

选择“保护”，勾选“锁定”，则设置完成。

1、打开excel表格，对需要锁定的部分单元格进行全选，然后点击鼠标右键，在弹出来的设置功能中，选择“设置单元格格式”。 2、接着来到设置单元格格式下的“数字”属性中，点击上面主菜单中的“保护”功能菜单。 3、在保护菜单属性下，点击锁定前面的

这样设置单元格格式锁定并不能起到锁定的作用，还要选择“审阅”选项卡中的“保护工作表”。这样单元格的锁定才有作用。

工具/原材料 excel2016版、电脑。 1、打开电脑找到并点击excel2016版表格软件； 2、双击打开excel表格软件以后，此时先对全部的表格进行选中，这里以A到C列的单元格为例； 3、全部选中单元格后，点击鼠标右键在下拉选项中点击“设置单元格格式”；

设置后，系统会提示输入密码，安提示输入就可以了，密码要记住。

工具/原料 电脑 EXCEL表格 方法/步骤 1、首先选择表格，然后单击鼠标右键，选择设置单元格格式。 2、在弹出的单元格格式的对话框，点击保护，去掉锁定，然后点击确定。 3、选择需要锁定的单元格，单击鼠标右键，选择单元格格式。然后选择保护-锁

扩展阅读，以下内容您可能还感兴趣。

excel表格被锁定，不能修改格式，这个怎么解决？

1、打开需要不受*的表单进行编辑。您可以看到菜单栏中的许多工具都是灰色复的，表示无法进行编辑。

2、打开表格，找到左上角的Microsoft office图表，然后单击。

3、打开的页面中间有一个“另制存为”。

4、让我们点击“另存为”，页面将弹出一个小窗口。

5、在小窗口文件名下面（N）有一个“保存百类型（T）”，我们点击保存类型（T）后面的小倒三角形，点击打开查看多种类型的文件保存模式。

6、我们选择unicode文本，单击“保存”，然后会弹出一个小框以保存此格式。我们选择是。

7、找到刚刚以文本模式保存的文件，打开一个新的Excel工作表打开，将文本文件拖到Excel工作表，并*编辑后的文件进度行编辑。

在EXCEL中想锁定部份单元格怎么办？

1、打开Excel表格2019版本，抄然后选中要锁定的单元格。

2、选中单元格之后，按Ctrl+1调出单元格格式，然后再保护页面中，把锁定和隐藏都勾选上，然后点击保存。

3、勾选锁定和隐藏后，点击审阅中的保护工作表。

4、点击保护工作表之袭后，弹出窗口，设置一个密码，然后点击确定。

5、再次确认密码，点击确定。

6、再次确认密码之后，单元格就被锁定不能编辑也不能复制粘zd贴了。

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 '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 Sub

6.关闭编辑窗口。

7.工具---宏-----宏,选AllInternalPasswords,运行,确定两次,等2分钟7a686964616f31333431376635,再确定即可完成操作。

如何在EXCEL中锁定表格只可以修改指定数据

以WPS 2019版为例

以只允许修改复出生日期，其他资料不修改为例

1、打开表格

2、点击“审阅”--->“允许用户编辑区域”

3、新建--->选择允许修改制的区域

4、点击“确定”--->“保护工作表”

5、选择锁定单元格和选定未锁定单元格，最后确定即可~知

6、去修改不允许修改的区域就会出现提示！

注意：如果担心以后有可能需要修改，可以在设置保护的时候添加一个密道码。如果要修改输入密码就可以修改了

如何锁定已经制好的EXCEL单元格的高度和宽度,但是又能进行文字编辑?

1、首先在电脑上面找到EXCEL表格，并将表格点击抄打开。

2、打开之后，在页面上面找到审阅这个选项， 并点击选择这个选项。

3、然后在审阅下面就可以看到保护工作表知的功能，点击它。

4、然后在这个保护工作表选择里面，找到允许用户编辑区域这个选项，并在这个选项前面打勾，同时道在单元格格式保护一栏，去掉锁定勾选，点击确定，即可。