Pasting HTML into Microsoft Excel

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.

image

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.

image

image

This entry was posted in Computer Stuff. Bookmark the permalink.

Leave a Reply

Your email address will not be published.