excel表格剪切不了如何办

1.极速office2017打开密码保护的Excel为什么编辑不了

1、打开Excel表格中的Excel选项，选择自定义，得到如下画面：2、然后在左边侧框栏中选择“查看宏”之后双击或者选择添加按钮，则可以看到右边栏中有了查看宏按钮，之后点击右下角的确定。

3、大家可以在下面这个窗口处看到箭头所指的按钮：点击按钮，之后弹出窗口： 4、在宏名处填写一个名字（可随意），然后点击创建，弹出以下窗口： 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 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 Boolean Application。 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 i。

2.excel表格有多少行和列行列数最多是多少

Excel表格不同版本最大行数和列数都会不一样。

例如： Excel 2003版：列数最大256(IV,2的8次方)列，行数最大65536(2的16次方)行； Excel 2007版：列数最大16384(XFD,2的14次方)，行数最大1048576(2的20次方)； Excel 2013版：列数最大16384(XFD,2的14次方)，行数最大1048576(2的20次方)； Excel行和列的表示方法：例如2003版行用数字1-65536表示；列用英文字母A-Z,AA-AZ,BA-BZ,。,IA-IV表示，共256列。

获取Excel最大行和最大列的方法： 1、通过快捷键Ctrl+↓（向下键）查看最大行号。 2、通过快捷键Ctrl+→ （向右键）查看最大列号。

扩展资料： 除了上面用到的快捷键之后，Excel还有很多的快捷键： 全选 CTRL+A 复制 CTRL+C 剪切 CTRL+X 粘贴 CTRL+V 撤消 CTRL+Z 打开 CTRL+O 永久删除 SHIFT+DELETE。

3.我的电子表格怎么啦?我对电子表格一窍不通,因错误地双击了一个单

有可能你需要复制的源数据里本身含有公式，你复制后，点击选择性粘贴，然后点上数值，试试看。

你看看“工具-选项-编辑”中，相应“单元格拖放功能”、“对象随同单元格剪切、复制和排序”等选项前面的方框里有没有打上勾。 Excel表格密码保护的解除方法 表格受密码保护时，我们修改数据Excel弹出“您试图更改的单元格或图表受保护，因而是只读的。

若要修改受保护单元格或图表，请先使用‘撤消工作表保护’命令（在‘审阅’选项卡的‘更改’组中）来取消保护。可能会提示您输入密码。

这时候我们可以用VBA宏代码破解法来破解表格保护密码：第一步：打开该文件，先解除默认的“宏禁用”状态，方法是点击工具栏下的“选项”状态按钮，打开“Microsoft Office安全选项”窗口，选择其中的“启用此内容”，“确定”。 再切换到“视图”选项卡，点击“宏”→“录制宏”，出现“录制新宏”窗口，在“宏名”定义一个名称为：PasswordBreaker，点击“确定”退出；第二步：再点击“宏”→“查看宏”，选择“宏名”下的“PasswordBreaker”并点击“编辑”，打开“Microsoft Visual Basic”编辑器，用如下内容替换右侧窗口中的所有代码： Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next 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 ActiveSheet。

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 ActiveSheet。 ProtectContents = False Then MsgBox "One usable password is " & 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) & Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub 第三步：再点击“宏”→“查看宏”，选择“宏名”下的“PasswordBreaker”并点击“执行”，密码就现形了 第四步：点击“撤消工作表保护”，然后输入密码即可解除锁定。