deleting 100's of pictures, keep data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
 
Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai
 
Tried that, it copied everything
--



Manish Bajpai said:
Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai
 
Try this

press F5
special
select objects
OK
Press the delete key
 
I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top