How to Skip Blank Cells in Excel – 2022’s Bonus

Skip Blanks or Skip Blank Cells 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 blank cells will be skipped.

Steps to Skip Blanks or Skip Blank Cells in Excel:

  • First, prepare the range A and B as given in the picture below
Values for skip blank cells
Values for skip blank cells
Select the range of cells and copy it
Select the range of cells and copy it
  • Select the range B (b12:b20) or right click at the beginning of the range B, then right and click Paste Special or use shortcut key (ctrl+alt+v).
Select the range B for skip blank cells
Select the range B for skip blank 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 in color for easy understand) 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. Then the Skip Blanks is very useful in Excel for this type of data.

See also  Ways to Apply Accounting Number Format in Excel - 2022

Related Posts: