Question: why excel cannot paste data?
Answer: As the main reason behind getting the error is it is not possible to paste data from a merged cell range into a non-merged cells range. So, to fix the error, choose the data > click on Merge and Center to toggle it off > try the copy the data again.