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
Watch video How do I skip blank cells while pasting in Excel - Excel Tips and Tricks online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 13 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,146 once and liked it 388 people.