Results 1 to 3 of 3

Thread: Duplicate drop down arrows

  1. #1

    Duplicate drop down arrows

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a golf team worksheet that has a drop down data validation list of opponent schools. Each time a match is played, the opponent team is selected from the list. In one cell, it shows 2 arrows when the cell is clicked on and 1 when clicked elsewhere. Both arrows show the opponent list. How can I get rid of one of them. I tried clearing the cell and entering the data validation again. Still, duplicate arrows. Help, please!

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    Can you clear the sensitive information and upload a copy?
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3

    Double Arrows

    Quote Originally Posted by Ken Puls View Post
    Can you clear the sensitive information and upload a copy?
    Thanks for the reply. I tried to copy the sheet (which is 1 of 22) to a new workbook, but it froze. Attached are 2 screenshot jpgs. The first one is without clicking in the cell. The second one shows the double arrow when the cell is clicked. Any ideas on how to get rid of the 2nd arrow?

    Thanks, Don
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Tourn.ScrSht.jpg 
Views:	13 
Size:	44.1 KB 
ID:	700   Click image for larger version. 

Name:	TournScrSht2.jpg 
Views:	13 
Size:	32.3 KB 
ID:	701  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts