This tutorial demonstrates how to copy and paste only populated cells, skipping blanks, in Excel.
Copy and Paste Non-Blanks Only
- First, select the data range you want to copy (in this example D2:D6), right-click on it, and choose Copy (or use the CTRL + C shortcut).
- Then, select the location where you want to paste the chosen data range. Right-click and, under Paste Options, choose Paste Special.
- The Paste Special window appears. In it, check the Skip blanks option and click OK.
As a result, only the cells with data are pasted, and the blanks from the selected data range won’t overwrite the existing values. In this example, only cells D3 and D5 are pasted into cells B3 and B5; B2, B4, and B6 remain the same.
Tip: Also check out VBA Value Paste & PasteSpecial.