![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://images.tips.net/S22/Figs/T13669F1.png)
#What are the different paste options in excel 2016 how to
This article about how to share a file via OneDrive link.ĭihao - * Beware of scammers posting fake support numbers here. Private message so that we can have a clear picture about your problem. You can send an attachment or a shareable OneDrive link with us via the If you are convenient, please share a set of sample data with us. You can click File > Account > Under Product information to find it.Ģ: Have you tried to copy and paste the data to a new Excel workbook? Did the same situation happen?ģ: May I know which types of data contain in your dataset that you fail to paste with paste special. To help us further narrow down the problem, please provide the following information to us.ġ: The screenshot of Excel client version you are using. I found that this dialog box will pop up in Excel when I used to paste special feature. However, when I tried to paste the data types such as Object, external data from Word document, etc. If there are any differences from yours, please point it out. Please take note that all the data I copied and pasted are numerical and text format.
![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://i.ytimg.com/vi/MZh9hnnVUas/maxresdefault.jpg)
I created a masterĬopy workbook in Excel and paste with “Skip blank” from another Excel workbook. I tried also reproduce this situation from my side. From your problem description, when your tried to paste some data with some blanks into your master copy spreadsheet, the paste special dialog box popped up as your screenshot shows.