Delete mass pictures and check boxes in a column

**SimonsGE** · 04-10-2013, 07:52 PM

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.

**newdoverman** · 04-10-2013, 08:10 PM

Click on Home tab, Find and Select, Go to Special, Objects. Click ok. All the objects such as check boxes and pictures will be selected. Hit DELETE and they will all be deleted. Select column A and right click in the column and select Clear Contents and column A will now be empty.

**SimonsGE** · 04-10-2013, 08:17 PM

with 2010, it is only removing all the background text and the picture and check boxes remain using the objects and the clear contents does the same thing when I add it back.