這會讓我們錯過一些數據而煩人，為了避免這種情況，Excel提供了一個功能 - 跳過空白讓我們解決這個問題。
1。 選擇要復制的數據范圍，然後按 按Ctrl + C 複製它。
2。 然後選擇您需要粘貼數據的另一個範圍或單元格，然後右鍵單擊，選擇 選擇性粘貼 > 選擇性粘貼 從上下文菜單中，看截圖：
3。 在 選擇性粘貼 對話框，檢查 跳過空白 選項，看截圖：
4。 然後點擊 OK 按鈕，並且範圍A的複制數據已粘貼到範圍B而沒有空白單元格。 看截圖：
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 4 months agoI 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.· 4 months agoHello,
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.