So, you need to add more columns to paste your information.

There may not be enough columns to store the data that you are pasting.Therefore you should try changing the cell format for the column. The data you are pasting may not have the same cell format (Date, Text, Time, etc.) in the column, and the 'Excel cannot paste data too many cell formats' problem may show up.If you can't paste in Excel, you can try the following troubleshooting steps to get going: Part 2: Pre Tips to Solve Excel Copy Paste Not Working Properly After knowing these, you can immediately tackle the concern. For example, you may have a merged cell that may not let your Excel paste the data and cause the problem, or you are inexperienced with the protocol of multiple pasting. You can fix an excel document that can’t paste data without hardly lifting a finger if the issue is a little one. 'Excel cannot paste the data' problem happens when you try to copy data from one Excel workbook and paste it onto the next. Why can't you copy/paste images in excel, but screenshots work? Part 1: Why Can't I Copy and Paste in Excel? How do you fix Excel Cannot insert the sheets into destination workbook?Ĥ. when cells are copied using excel’s copy function, what happens to the data in the copied cells?ģ. How to copy and paste in excel without changing the format?Ģ.

Format date cells in excel not working