Digital Spy

Search Digital Spy
 

DS Forums

 
 

Deleting multiple images in Excel


Reply
Thread Tools Search this Thread
Old 06-03-2013, 14:24
JIMO96
Forum Member
 
Join Date: Dec 2005
Posts: 176

Can anyone suggest a way to solve an annoying issue?

I've been copying tabulated data from a website onto a spreadsheet....unfortunately, the data contains many images in the form of "logos" within it's cells, which automatically appear on Excel, once copied.

Is there an easy way to select them all for deletion? I mean, without clicking on each one in turn and holding down "Ctrl"?

It won't let me simply "delete column" (they refuse to go away!)

Any ideas?
JIMO96 is offline   Reply With Quote
Please sign in or register to remove this advertisement.
Old 06-03-2013, 14:52
flagpole
Inactive Member
 
Join Date: Jan 2003
Posts: 43,524
one thing that springs to mind would be to save, export, copy etc your spreadsheet with a format that does not support images.
flagpole is offline   Reply With Quote
Old 06-03-2013, 15:00
chrisjr
Forum Member
 
Join Date: May 2004
Location: Reading
Posts: 21,773
I wonder if pasting the table into Word first would allow the images to be removed? If they are in a single column Word may let you delete the column. Then you can copy and paste into Excel.

Alternatively use the Convert Table to Text option in Word and use Tabs as the delimiters. Then save the file as plain text. That should get rid of the images (will also probably generate several warnings). You should then be able to import the tab delimited file back into Excel. You'll also lose any text formatting doing it like this if that is important to you.
chrisjr is offline   Reply With Quote
Old 06-03-2013, 15:05
John259
Forum Member
 
Join Date: Nov 2003
Location: Norwich, Norfolk, UK
Posts: 13,224
Are all the images in columns by themselves (so the problem amounts to wanting to delete some complete columns but it won't let you do that)?

If so, then you could copy and paste each of the columns you want to keep into a new spreadsheet, omitting the columns with the images but leaving those columns in the new spreadsheet empty. Then delete the empty columns in the new spreadsheet, which should automatically adjust all the formulas.

Apologies if I've misunderstood the problem.
John259 is offline   Reply With Quote
Old 07-03-2013, 05:39
Helmut10
Forum Member
 
Join Date: Dec 2011
Posts: 407
I think you will find those Images are not in the Cells.

The Images move with the cells due to their Properties if you look, so they just appear to be in the cells.

Which is why you can select them all and Delete, but selecting the Row/Column then Deleting Contents does not work.

I'm sure you can write a Excel Macro to do the job with one key press. Worth doing if it's a regular thing.

Pasting into Word resulting in a table and so on. Then into Excel, I would think even more long winded, but eventually it should work.
Helmut10 is offline   Reply With Quote
Old 07-03-2013, 11:43
platelet
Forum Member
 
Join Date: May 2002
Location: GL51 0EX
Posts: 7,170
have you tried:

when pasting right click and choose paste special. then choose the option for text
platelet is offline   Reply With Quote
Old 07-03-2013, 11:59
lettice
Forum Member
 
Join Date: Mar 2000
Posts: 2,799
The best way to do this is to use a web query from within excel
lettice is offline   Reply With Quote
Old 07-03-2013, 14:03
JIMO96
Forum Member
 
Join Date: Dec 2005
Posts: 176
Thanks everyone for the suggestions.....the problem is solved, having pooled a few of the ideas generated here together.

The "macro" thing is beyond my capabilities I'm afraid, but the solution was far simpler: it turns out I could extract the data from within the cells that contained both data and images. So it was just a case of saving that data to another worksheet, and deleting the sheet I'd copied it to originally(!)

God I can be so thick sometimes....it just needs a quick visit here for the solution, or for someone to get me thinking along the right lines. Thanks again guys!
JIMO96 is offline   Reply With Quote
 
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search

 
Forum Jump


All times are GMT +1. The time now is 22:54.