skip blank excel
by

Skip Blanks in Excel

Skip blanks in Excel is the “Paste Special” option. When using this option checked, Excel will not overwrite existing cell values with blanks. Let’s understand this better with the example below.

1. Select the cell range E3:E8.

skip blanks in excel

2. Right click and copy the selected range (keyboard shortcut: CTRL+c)

select a range

3. Select cell D3. Right click, and click Paste Special. In the following dialog box, check “Skip blanks”.

paste special dialog box

4. Click Ok.

skipped blank excel cells

8 of 12 finished! Recommending more on the Range: Next Example >>
<< Previous Example | Skip to Next Chapter 03: Understanding Workbook