The skip blank cells option helps when you’re working with large amounts of data, it can be difficult to skip and keep track of a few blank cells in the middle of the data in the column or table you’re working with. Fortunately, Microsoft Excel has a built-in feature that can help ease your workload.
For example, if you copy cells with and without a value in range A and apply them to range B filled with values, the values will be replaced and the blank cells will be skipped.
How to Skip Blank Cells in Excel
First, prepare the range A and B as given in the picture below
Select range B (b12:b20) or right-click at the beginning of range B, then right and click Paste Special or use the shortcut key (ctrl+alt+v).
After clicking on the Paste Special, a dialogue box will open. Now, checkmark the skip blanks and click OK.
Now as in the picture below, values are overwritten (values are formatted with red colour for easy understanding) and blank cells are skipped.
It is very difficult to skip blank cells and replace values manually when there is huge and different data in the same range.