Scroll icon in every row. How to get ride of?

Help please...

I was creating an array and copying it down; somehow there is now an icon of a scroll in every one of those cells--even though the array has been deleted.  The only way I've found to get rid of the icon is to click on and delete it.  I have 9900 rows with it so this is unfeasible.   When I deleted the column they were in they moved to the next column.  Is there a way to delete them?

Thanks.
FFNStaffAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
You may need to repeat this several times to catch all the objects.

I just copied and pasted a web page into Excel. The first round of F5 > Special > Objects > Delete only deleted the images. The script icons were still showing. The next cycle of F5 > Special > Objects > Deleted the script icons.

In the first screenshot you can see parts of the script showing when the mouse hovers over a script icon.
In the second screenshot you see the script icons selected (that was the second cycle of F5 etc.)


28-09-2011-9-10-17-a.m..png
28-09-2011-9-10-43-a.m..png
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

"icon of a scroll"? This sounds like you copied content from the web and the html code contained code, like JavaScript.

Try this:

Hit F9, click Special, tick Objects and hit OK. Hit the Delete key.

Are the scroll icons gone now?

cheers, teylyn
0
 
FFNStaffAuthor Commented:
The F9 key doesn't do anything...  Is there another way to get to whatever you're referencing?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Typo, F5, Sorry, I meant F5.

This opens the GoTo dialog.
0
 
FFNStaffAuthor Commented:
Teylyn, sorry for the delay.  Tried several times, didn't work.  Any other suggestions?
0
 
FFNStaffAuthor Commented:
The file is so big it must have just taken a long time for the process to work.  Thanks again for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.