提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
注册账户
x

or

如何复制和粘贴在Excel中跳过空白单元格?

通常,当我们复制范围A中包含空白的一些数据单元并将它们粘贴到另一个范围B时,空白单元格也将被粘贴,并且范围B的原始数据将被忽略。 请参阅以下屏幕截图:

DOC  - 复制 - 跳过空白,1 -2 DOC  - 复制 - 跳过空白,2

这会让我们错过一些数据而烦人,为了避免这种情况,Excel提供了一个功能 - 跳过空白让我们解决这个问题。

使用选择性粘贴功能复制并粘贴空白单元格

使您能够更智能,更快速,更好地完成工作

Kutools - 最好的办公生产力工具为300带来了高级功能。 细节... 下载...

Office选项卡 - 为Excel和Word提供选项卡式界面,使您的工作更轻松。 细节...下载...


箭头蓝色右泡 使用选择性粘贴功能复制并粘贴空白单元格


Excel中的跳过空白功能允许我们复制空白单元格的数据范围,并将数据粘贴到另一个区域,而不用空白覆盖现有数据。 请遵循以下步骤:

1。 选择要复制的数据范围,然后按 按Ctrl + C 复制它。

2。 然后选择您需要粘贴数据的另一个范围或单元格,然后右键单击,选择 选择性粘贴 > 选择性粘贴 从上下文菜单中,看截图:

DOC  - 复制 - 跳过空白,2

3。 在 选择性粘贴 对话框,检查 跳过空白 选项,看截图:

DOC  - 复制 - 跳过空白,2

4。 然后点击 OK 按钮,并且范围A的复制数据已被粘贴到范围B而没有空白单元格。 看截图:

DOC  - 复制 - 跳过空白,2


相关文章:

如何复制和粘贴Excel中的非空白单元格?



Excel生产力工具

Kutools for Excel - 最佳办公生产力工具

  • 为300带来强大的高级功能,使您能够更智能,更快速,更好地完成任务。
  • 不再需要记忆公式和VBA代码,从现在起让你的大脑休息一下。
  • 成为3分钟的Excel专家,复杂和重复的操作可以在几秒钟内完成,
  • 每天减少成千上万的键盘和鼠标操作,现在告别职业病。
  • 110,000高效人才和300 +世界知名公司的选择。
  • 60-day full功能免费试用。 60天退款保证。 2多年的免费升级和支持。

Office选项卡 - 为Office提供选项卡式界面,使您的工作更轻松。

  • 在Word,Excel,PowerPoint,Publisher,Access,Visio和Project中启用选项卡式编辑和阅读。
  • 在同一窗口的新选项卡中打开并创建多个文档,而不是在新窗口中。
  • 通过50%提高您的工作效率,每天为您减少数百次鼠标点击!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    E · 4 months ago
    I should add that when I use the GO TO dialog box then SPECIAL and choose BLANKS, a message pops up and tells me there are no blanks even though there are. When I click on one of these "blank" cells there is nothing in the cell or in the display field up top where the cell contents also show.
  • To post as a guest, your comment is unpublished.
    E · 4 months ago
    Hello,
    The “skip blanks” feature in the Paste Special dialog box does not work for me. I have a list of names in Column B and the person’s STATUS in column H. If the person has a PAID status in Column H, I used this formula to extract the name from Column B: =IF(H6="PAID",B6,"")

    There are over 600 names with PAID and NONE statuses. The formula worked perfectly. Now I need to copy and paste those names into another column so only the values show.

    I copied the names (which really are just the formula that produced the name) and used the Paste Special dialog box to paste that data into another column using the option to paste the values only. I checked the “skip blanks” option and hit OK.

    The blanks appeared as well. I tried changing the formula to =IF(H6="PAID",B6," ") so there is a space between the two italics and that did not help. I tried =IF(H6="PAID",B6, ) just leaving the “if false” section completely blank and I got the same results.

    I sorted the data which got rid of the blanks but now the names were out of order due to some cells containing Mr or Mrs or no title.

    ANY HELP would be appreciated. I'm using MS Excel for Office 365.
    Thanks in advance.