I frequently find that I need to paste data from the web into Excel. Sometimes that operation drags along a bunch of unwanted controls that are really difficult to remove.
The simplest way I know of to remove these is to copy the data to a new sheet in the workbook using Paste Special and then remove the original content.
- Paste the original data into a worksheet.
- Select/Copy all the content in the sheet with Ctrl-A and Ctrl-C.
- Open a new Sheet in the workbook and Right-Mouse->Paste Special. Select “Values†and click OK.
- Go back and delete the previous sheet.
Maybe there are some easier ways, but this isn’t too bad.
