Most valuable professional
  • Excel Book Excerpt

Excel Delete All Pictures in Pasted Data

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Delete All Pictures in Pasted Data

Problem: I copy data from my bank’s Web page into Excel. On the Web page, the bank has little check icons that let me view a physical copy of a check. These check icons show up as annoying images in my Excel workbook. How can I delete all these images in one step?

LE10001193.jpg 

Figure 1152 Delete all images.

Strategy: Excel offers a tool, Select Objects, that allows you to select all images in a rectangular area. Use, Home, Find & Select, Select Objects.

Using the mouse, start highlighting above and to the left of the first cell that contains a picture. Drag down and to the right to encompass all the cells that contain pictures. When you release the mouse button, all pictures that are completely contained in the rectangle will be selected. At this point, press the Delete key.

Gotcha: You have to remember to turn off Select Objects mode, or you will no longer be able to select any cells. It is very annoying to try to select cells and have the mouse not respond to clicking. To exit Select Objects mode, you simply press the Esc key.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: