Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-01-2014, 06:52 AM
aleman aleman is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2014
Posts: 4
aleman is on a distinguished road
Default Problem for deleting the drop down icon box


Dear All,
Encl pls find print screen which the drop down icon exist in my file.
I have no idea how it's come up as I did not set up any validation or drop down list.
I have tried delete the row that appear those box. After I delete the row, it's still exist in another row. I also try to find in Google to find some solution but still no chance to get rid of it.
Any expert can help, tks in advance.
Attached Images
File Type: png EXCEL problem.png (22.1 KB, 3 views)
Reply With Quote
  #2  
Old 09-01-2014, 07:13 AM
MetroBOS MetroBOS is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 10
MetroBOS is on a distinguished road
Default

I'm not 100% sure if this will work for dropdown boxes, but it works for removing checkboxes, so it's worth a shot.

Press the F5 key
Click Special
Select Objects
Click OK
At this point, the dropdown box should be highlighted
Press the Delete key to remove it

Hope that works for you!
Reply With Quote
  #3  
Old 09-01-2014, 09:08 AM
aleman aleman is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2014
Posts: 4
aleman is on a distinguished road
Default

I tried it but when I press F5 function key, it does not pop up anything.
It might be I am using the French version Excel.
How do you go to get the function to find Subject, is it also you can find it in developer tools ?
If I remind, it seems that I have already tried this way but it does not related.
Reply With Quote
  #4  
Old 09-01-2014, 09:13 AM
MetroBOS MetroBOS is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 10
MetroBOS is on a distinguished road
Default

F5 opens the Go To menu. If F5 doesn't work for you, you could also try CTRL+G or from the Home Tab, click Find & Select and choose Go To.
Reply With Quote
  #5  
Old 09-09-2014, 07:56 AM
aleman aleman is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2014
Posts: 4
aleman is on a distinguished road
Default

Finally I find the Go to Special & try to go to object. But it show that it's no object in my table. So no luck on it.
If anybody has any idea what's that exactly & how to delete this boxes, it's so annoying especially when I do the sorting in Column A as it's block the filter so I can not do anything. When I click on those box, there is blank & no information on it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drag & Drop file as icon to rtf doc pro3carp3 Word 0 03-26-2013 06:36 AM
Problem with paint icon in miscroft excel Confuse2 Excel 1 08-03-2012 05:32 AM
sort & filter icon not available or icon not highlighted survivo01 Excel 1 08-08-2011 03:41 AM
Deleting text problem XswordcraftX Word 2 11-17-2008 03:12 AM
Email deleting problem Mungpo Outlook 1 08-24-2006 05:37 AM


All times are GMT -7. The time now is 01:57 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft