How do I skip blank cells while pasting in Excel - Excel Tips and Tricks

Learn how to skip blank cells while pasting in Excel. Or in other words, how do I paste and skip blank cell? Alternatively, how do I copy and paste only filled cells in Excel? Another way to ask the question is how do I paste only cells with values?

Here are the steps outlined on the video.

Paste and skip blank cell
1) Highlight column C data
2) Ctrl + C
3) Right-click on B2
4) Special paste...
OR
Alt + E+ S
5) Check on Skip blanks
6) OK

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[misterwill]

I enjoy watching your videos. I see things that I never imagined possible in Excel. 👏🏾

[eversut]

Very useful video. Thanks for sharing.

[enrikekasijas]

Wow...I was always adding filter and selecting visible cells and then moving them to the left 😂 thx 🎉

[tahirshah]

Hahaha
I have used all options of paste special but have not used this one.
I have used if(C1>0, C1, B1) and paste special at column B.