Results 1 to 4 of 4

Delete mass pictures and check boxes in a column

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Silverdale, WA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Delete mass pictures and check boxes in a column

    When I copy and paste information off the Safeway website for coupons, it adds pictures and a check box down the column in certain areas. when I clear the cells, it deletes everything but the pictures and check boxes. I can deleted the pictures 1 by 1 but takes forever with over 100 rows and I have not figured how to delete the check boxes. Is there a way to delete the pictures and check boxes with just 1 button or will this need to be done manually for each one and if it cant, how do I target and delete the check boxes? It sounds a little confusing so I am adding the worksheet so it can be seen on the sheet 2 for Safeway, all in column A2-A752 atm. Any time I paste new data from the site, it starts to overlap pictures and takes up a lot more space on the file.(the other sheets are still a work in progress and are not working as of yet past FredMeyer. I had to manually deleted a large group of pictures to make file small enough). Any Help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1