提示:其他語言是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.