#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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.
|
#5
|
|||
|
|||
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. |
|
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 |