Dropdown in Excel

[nagapavan]

Hi,

I have copied a drop down value from a HTML page to excel and this drop down is showing up in execl and I am unable to delete it by either deleting the rows or columns. What do I do to remove the dropdown value in the sheet?

Pavan

 

[Stormseed]

Is that HTML dropdown copied and pasted as an image on your worksheet ? Could you post a screenshot of your worksheet here ?

 

[nagapavan]

I am unable to paste the screen shot. can you help me?

 

[msaiyad]

go to this post, download one of the add-ins, and post samples of your sheets with them.
Please download an HTML Maker and post sample data with what results you expect<!-- / message --><!-- sig -->

 

[Smitty]

It sounds like you may have pasted an image, as opposed to text. Can you left-click it then hit delete or Ctrl+X?

HTH,

 

[techquility]

It sounds like the drop down became an object when you pasted it in. What version of excel are you using?

 

[nagapavan]

I cannot install the addin as I am in office. I do not have permissions

 

[nagapavan]

I am using Excel 2003.

 

[techquility]

You need to get the select objects arrow. If you have the drawing toolbar in view, click on the icon that looks like an arrow. You should be able to then click the drop down and just delete it.

If your drawing toolbar is not displayed, go to: View | Toolbars | Drawing

Once you have deleted the object, make sure to deselect the Select Objects arrow in the toolbar or else you won't be able to click on cells.

Hope this helps!

 

[nagapavan]

Sorry, but this does not help. I am unable to select the dropdown after clicking the arrow. It prompts me to draw the arrow at a place in the sheet.