Excel Copy Paste Multiple Values only in Blank cells
If you have list with blank cells and you want to
paste some data in blank cells only without changing other cells then
follow below process.
Below I have written few numbers with blank cells and I want to paste remaining numbers in blank cells.
I have also remaining number in other column like below.
If we copy above range and paste into first image then it will give us same data display in 2nd image. But we don’t want same data. We want to copy above data and paste it into blank cells only.
To copy and paste into blank cells only follow below process. It is very easy.
First Copy the Range you want to paste it. Here
Range in column J. Then come to column D1 and Right click and select
option Paste Special.
In Paste Special – Select Option Values and check
mark on Skip blanks. Then press OK. Now you can see numbers only paste
in blank cells an all other cells remain same as per below.
Hope you understand. If you have any issue then feel free to comment.
Thank you
Watch Video -
No comments:
Post a Comment