Pin Me

Microsoft Excel: Delete All Pictures In Pasted Data

written by: Mr Excel•edited by: Michele McDonough•updated: 7/6/2011

Problem: You copy data from your bank’s Web page into Excel. On the Web page, the bank has little “check” icons that let you view a physical copy of the check, as shown in Fig. 1326.

  • slide 1 of 3

    As shown in Fig. 1327, this check icon shows up as an annoying image in your Excel workbook. How can you delete all of these images in one step? (Click any image below for a larger view.)

    Strategy: There is a tool in the Drawing toolbar that allows you to select all images in a rectangular area.

    1) To display the Drawing toolbar, select View – Toolbars – Drawing. On the left side of the Drawing toolbar is a white arrow, as shown in Fig. 1328. This is called the Select Objects tool.

    2) Choose the Select Objects tool. When you are in Select Objects mode, the white arrow will have a blue square around it, as shown in Fig. 1328.

    3) Using the mouse, start highlighting above and to the left of the first cell with the check icon. Drag down and to the right to highlight all of the cells with the check icons. As shown in Fig. 1329, all of thedrawing objects in the rectangle will be selected.

    4) Hit the Delete key on the keyboard to delete all of the selected objects at once.

    Gotcha: You have to remember to turn off the Select Objects mode by choosing the white arrow in the Drawing toolbar again. It is very annoying to try to select cells and have the mouse not respond to clicking when you forget to turn the white arrow off.

    Summary: Use the Drawing toolbar to select all images in a rectangular range.

    Commands Discussed: View – Toolbars – Drawing

  • slide 2 of 3


    Fig. 1326Fig. 1327Fig. 1328Fig. 1329
  • slide 3 of 3

    References and Additional Resources

    If you're looking for more tips and tutorials, check out 91 Tips for Calculating With Microsoft Excel. This collection of easy-to-follow guides shows how to customize charts and graphs, different ways to make complex spreadsheets easier to update, and even how to play games like Craps in Excel.

    Other Resources:

    Microsoft Excel Official Site,

    Bill Jelen, Microsoft Excel 2010 In Depth, Available from