How to Skip Blank Cells in Excel – 2022

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

Adding Values
Adding Values

In range A, select the cells range (d12:d2o) from d12 to d2o and copy it.

Select the range of cells and copy it
Select the range of cells and copy it

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).

Select the range B for skipping empty cells
Select the range B for skipping empty cells

After clicking on the Paste Special, a dialogue box will open. Now, checkmark the skip blanks and click OK.

Checkmark the Skip Blanks
Checkmark the Skip Blanks

Now as in the picture below, values are overwritten (values are formatted with red colour for easy understanding) and blank cells are skipped.

Blank cells are skipped and values are overwritten
Blank cells are skipped and values are overwritten

It is very difficult to skip blank cells and replace values manually when there is huge and different data in the same range.

What are Skip Blanks in MS Excel?

It means, for example, if you copy the cells with and without value in a range called A and apply it to range B which is filled with values, then the values will be overwritten and the black cells will be skipped.

Share