Results 1 to 3 of 3

Thread: How to hide drop down arrows in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    40

    How to hide drop down arrows in Excel

    Months ago, I created a drop down list for one of the columns on my worksheet. Since then, I have decided to eliminate the list. I went in to the place where I defined the range and deleted the name. I also deleted the referenced range. But, when I click on a cell in this column I still get the drop down arrow, even though the list is empty. How do I get rid of the arrow? So is there any way to hide or to stop this drop down arrows in Excel. If you guys have any information then please let me know.

  2. #2
    Join Date
    Jul 2011
    Posts
    623

    Re: How to hide drop down arrows in Excel

    According to my information these drop down arrows in Excel is for the Data-Validation, that inform about the input for the correct data type at the respective place.

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    Re: How to hide drop down arrows in Excel

    More than likely you have the data validation still set. There is the need to turn off, so To turn it off, you just have to go to the standard toolbar, and then hit Data -> Validation, and then hit the "Clear All" button at the bottom left side of the dialog box. May this will help you out to get over your query.

Similar Threads

  1. Excel 2010 - drop down menus help
    By MadHatter in forum Windows Software
    Replies: 1
    Last Post: 10-02-2012, 12:07 AM
  2. I need help to update drop down list on Microsoft Excel
    By Tur^turro in forum MS Office Support
    Replies: 3
    Last Post: 28-01-2012, 03:57 PM
  3. Creating Drop down Calendar in excel
    By Sanju!Ekta in forum Software Development
    Replies: 7
    Last Post: 16-07-2011, 10:57 AM
  4. How can i hide formulas in MS Excel
    By Orton in forum Windows Software
    Replies: 3
    Last Post: 04-07-2009, 08:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,176,006.55032 seconds with 17 queries