Excel复制和粘贴提示和问题

Copy and paste. It's one of the first things you learn to do in Excel, and something you do every day. Without copy and paste, your Excel work would take much longer, and you'd be exhausted by the end of the day, from all that typing! Here are some Excel copy and paste tips and trouble shooting suggestions.

复制和粘贴。 这是您在Excel中学习要做的第一件事，也是您每天要做的事情。 如果没有复制和粘贴，则您的Excel工作将花费更长的时间，并且到最后您会因为所有键入而筋疲力尽！ 以下是一些Excel复制和粘贴提示以及解决问题的建议。

复制和粘贴 (Copy and Paste)

With copy and paste, you can select a huge range of cells, with dates, text, numbers and complicated formulas, and paste them on a different sheet, or another workbook. It's so quick and easy to do, that you take it for granted. Until something goes horribly wrong!

使用复制和粘贴，您可以选择范围广泛的单元格，包括日期，文本，数字和复杂的公式，然后将它们粘贴到其他工作表或其他工作簿上。 它是如此快速且容易实现，以至于您将其视为理所当然。 直到出现严重错误！

This video shows some of the problems, and the written details are below the video.

该视频显示了一些问题，书面细节在视频下方。

NOTE: Updated with new, improved video (Feb 5, 2020)

注意：已更新并改进了新的视频(2020年2月5日)

演示地址

复制和粘贴灾难 (Copy and Paste Catastrophe)

Last week, I was merrily copying and pasting data from one workbook to another, and everything was going well -- or so I thought. The data was in a table, like the one shown below, with formulas in a few of the columns.

上周，我很高兴地将数据从一个工作簿复制并粘贴到另一个工作簿，并且一切进展顺利-大概就是这样。 数据在一个表格中，如下表所示，其中的几列中包含公式。

I didn't need all the data in the new workbook, so I copied the top section, and pasted it. Then, I copied a few sections in the middle, by pressing the Ctrl key as I selected different ranges.

我不需要新工作簿中的所有数据，因此我复制了顶部并粘贴了。 然后，在选择不同范围时，通过按Ctrl键，在中间复制了几部分。

Then, I changed one of the amounts in the copied data, and noticed a problem -- the total didn't change. Shown below is the copied data, with Show Formulas turned on.

然后，我更改了复制数据中的一个数量，发现一个问题-总数没有变化。 下面显示的是复制的数据，其中“显示公式”已打开。

For the rows that I pasted as multiple range selections, the values were pasted -- not the formulas. Yikes! That could create serious problems, if you didn't notice the missing formulas.

对于粘贴为多个范围选择的行，将粘贴值-而不是公式。 kes！ 如果您不注意缺少的公式，则可能会造成严重的问题。

保持公式 (Keep Your Formulas)

To keep your formulas, when you've copied multiple selections, follow these steps when pasting:

为了保留您的公式，当您复制多个选择时，请在粘贴时执行以下步骤：

• Copy the multiple selections
  复制多个选择
• Right-click the cell where you want to start the paste
  右键单击要开始粘贴的单元格
• In the pop-up menu, click Paste Special
  在弹出菜单中，单击“选择性粘贴”
• In the Paste Special window, click OK
  在选择性粘贴窗口中，单击确定。

复制多项选择错误 (Copy Multiple Selections Error)

Sometimes you might select multiple ranges, and when you try to copy them you see an error message, "That command cannot be used on multiple selections."

有时您可能会选择多个范围，并且当您尝试复制它们时，会看到错误消息，“该命令不能用于多个选择。”

If you're planning to copy them, the selected ranges must include exactly the same rows or columns. For example, if your first selection is B1:D6, you can also select H1:H6 (same rows), but not H1:H5 (different rows).

如果您打算复制它们，则所选范围必须包括完全相同的行或列。 例如，如果第一个选择是B1：D6，则还可以选择H1：H6(相同的行)，但不能选择H1：H5(不同的行)。

You can select multiple ranges in different rows or columns, as long as you keep the ranges consistent. In the screenshot below, B1:D6 and H1:H6 were selected. Then, B9:D10 and H9:H10 were selected, and those four ranges were copied.

您可以在不同的行或列中选择多个范围，只要保持范围一致即可。 在下面的屏幕截图中，选择了B1：D6和H1：H6。 然后，选择B9：D10和H9：H10，并复制这四个范围。

Each selected row has identical ranges selected (B:D, H) and each selected column has identical ranges selected (1:6, 9:10)

所选的每一行具有相同的范围(B：D，H)，所选的每一列具有相同的范围(1：6、9：10)

Happy copying! ___________

复制愉快！ ___________

翻译自: https://contexturesblog.com/archives/2010/11/26/excel-copy-and-paste-tips-and-trouble/