Question: how to copy and paste only 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: