如何解决Excel复制和粘贴问题

Copying and pasting can save you lots of time in Excel. Imagine if you had to manually re-enter all that data instead!. Occasionally though, you might run into problems. See how to fix Excel copy and paste problems when you're working with multiple selections. One problem is sneaky, and you might not even know it's happening!

复制和粘贴可以在Excel中节省大量时间。 想象一下，如果您不得不手动重新输入所有这些数据！ 有时候，您可能会遇到问题。 查看使用多个选择时如何解决Excel复制和粘贴问题。 一个问题是偷偷摸摸，您甚至可能不知道它正在发生！

复制和粘贴问题 (Copy and Paste Problems)

First, watch this short video, to see two problems you might have when copying and pasting multiple selections. The written notes are below the video.

首先，观看此短片，以了解复制和粘贴多个选择时可能遇到的两个问题。 书面说明在视频下方。

To follow along with the video, go to my Contextures site, and get the sample file.

要继续观看视频，请转到我的Contextures网站，并获取示例文件 。

演示地址

Video Timeline:

视频时间轴：

• 0:00 -- Introduction
  0:00-简介
• 0:15 -- Copy Error Message
  0:15-复制错误消息
• 0:42 -- Avoid the Error Message
  0:42-避免出现错误信息
• 1:54 -- Paste Problem
  1:54-粘贴问题
• 2:40 -- Copy 2 Ranges
  2:40-复制2个范围
• 3:23 -- Paste With Formulas
  3:23-用公式粘贴
• 4:13 -- Get the Workbook
  4:13-获取工作簿

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

First, here's an Excel copy and paste problem that you might run into, if you select more than one group of cells on a worksheet, and try to copy them.

首先，这是一个Excel复制和粘贴问题，如果您在工作表上选择多个单元格并尝试复制它们，则可能会遇到此问题。

Things might work smoothly for a while, then suddenly Excel shows a message that warns you, "This action won't work on multiple selections."

事情可能会运行一段时间，然后Excel突然显示一条消息，警告您：“此操作不适用于多个选择。”

为什么会看到复制错误 (Why You See the Copy Error)

Excel will show that error message if you selected multiple ranges, and those ranges don't "match up".

如果您选择了多个范围，并且这些范围不“匹配”，Excel将显示该错误消息。

For example, Excel will show a warning message if

例如，如果出现以下情况，Excel将显示警告消息

1. you select cells in columns A:C
   您在A：C列中选择单元格
2. then you make another selection in different columns, A:B
   然后在不同的列中进行另一个选择A：B
3. Then you press Ctrl+C to copy (or use another method to copy)
   然后按Ctrl + C进行复制(或使用其他方法进行复制)

避免复制错误 (Avoid the Copy Error)

Here's how to avoid that Excel copy and paste problem, so you don't see the multiple selections copy error.

这是避免Excel复制和粘贴问题的方法，因此您不会看到多选复制错误。

When you're selecting the cells, be sure to select regions that are:

选择单元格时，请确保选择以下区域：

• in the exact same columns
  在完全相同的列中
• OR, in the exact same rows
  或者，在完全相同的行中

Even one wrong cell will cause that error message!

即使是一个错误的单元格也会导致该错误消息！

So, be sure that each selection includes exactly the same rows or columns. The next example, won't cause Excel copy and paste problems, because both selections are in columns A:C.

因此，请确保每个选择都包括完全相同的行或列。 下一个示例将不会导致Excel复制和粘贴问题，因为两个选择都在A：C列中。

多项选择的粘贴问题 (Paste Problem for Multiple Selections)

Next, here's another problem you can run into, when working with multiple selections. And this problem can be worse, because Excel doesn't give you a warning message!

接下来，使用多个选择时，您可能会遇到另一个问题。 而且这个问题可能更严重，因为Excel不会给您警告消息！

So heed this warning instead! If you copy more than one group of cells on a worksheet, and paste them in a different location, Excel might change your formulas to values.

因此，请注意此警告！ 如果您在工作表上复制一组以上的单元格，并将其粘贴到其他位置，则Excel可能会将您的公式更改为value 。

That could definitely cause problems later, if you don't notice that it happened!

如果您不注意发生的话，那肯定会在以后引起问题！

如何粘贴公式 (How to Paste the Formulas)

To keep the formulas, follow these steps:

要保留公式，请按照下列步骤操作：

• 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
  在选择性粘贴窗口中，单击确定。

That way, all your formulas will be pasted too, and you can avoid the fallout from Excel copy and paste problems later.

这样，您的所有公式也将被粘贴，并且以后可以避免Excel复制和粘贴问题带来的影响。

获取样本文件 (Get the Sample File)

To get the Excel copy and paste problems sample file, and see more tips and videos, go to the Data Entry Tips page on my Contextures site.

要获取Excel复制和粘贴问题示例文件，并查看更多提示和视频，请转到Contextures网站上的“数据输入提示”页面 。

翻译自: https://contexturesblog.com/archives/2020/02/06/how-to-fix-excel-copy-and-paste-problems/