Question: how to copy and paste non blank cells in excel?
Answer: Select the cells, including the blank and non-blank cells that you wish to paste.
On the Home tab, in the Editing group, select Sort & Filter and then choose Filter (or click Ctrl+Shift+L):
A drop-down should appear in the first cell of your range.
De-select the (Blanks) option and then click on the OK button: