Question: how to copy and paste in excel with blank cells?
Answer: Press [Ctrl]+[Enter] and Excel will copy the respective formula to all blank cells in the selected range.