How to remove all inserted picture at one go?

**Lewis Koh** · 05-30-2010, 01:58 AM

Hi,

Is there any way to remove all pictures in a tab without deleting other cell formula? I have a page with thousands of insert pictures and every picture below has comments that is copied form our worksheets. I want to keep the formulas in the cells but remove all pictures.

**teylyn** · 05-30-2010, 02:04 AM

F5 - Special - click Objects - OK - hit delete

**dlairman** · 02-24-2012, 11:03 AM

teylyn - Brilliant! Big timesaver, thanks!

**royUK** · 02-24-2012, 12:06 PM

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save