This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I copy/paste information from web pages to Excel on a regular basis. Currently, I am forced to copy text from web page, right click the cell in Excel, select "Paste Special..." from the context menu, the select "Unicode text" from the listed options. Very cumbersome, and it slows me down. Likewise the option of using Ctrl-V, then hitting the icon to bring up the Paste Options, and clicking on the icon representing "Match Destination Formating".
How to set this so I can Ctrl-C selected text from a web page, and Ctrl-V into a cell in Excel, to DEFAULT to Unicode text without source formatting?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
What a complete waste of a program. It used to be able to do that. I can't even get a hold of anyone for a refund at this point.
Afraid there is no such option