Copy and paste only nonblank cells
One of the solutions is to use a Filter:
1. Select the cells, including the blank and non-blank cells that you wish to paste.
2. On the Home tab, in the Editing group, select Sort & Filter and then choose Filter (or click Ctrl+Shift+L):
![Filter in Excel for Microsoft 365 Filter in Excel 365](/images/tips/excel_button365/filter.png)
3. A drop-down should appear in the first cell of your range.
![Filter in Excel for Microsoft 365 Filter in Excel 365](/images/tips/331_365/1.png)
Click on this drop-down.
4. De-select the (Blanks) option and then click on the OK button:
![Filter in Excel for Microsoft 365 Filter in Excel 365](/images/tips/331_365/2.png)
5. You can see now only non-blank cells; select them:
![Series without blank cells in Excel for Microsoft 365 Series without blank cells in Excel 365](/images/tips/331_365/3.png)
6. Now, you can copy and paste anywhere the series of cells without blank cells:
![Example in Excel for Microsoft 365 Example in Excel 365](/images/tips/331_365/4.png)
See also this tip in French: Comment copier et coller uniquement les cellules non vides.