Hi All,
I recently started using excel 2016, and this data / sheet is created by an employee who left.
There are many validation lists in workbook , when you select that cell , drop down arrow is visble , which is default/knowm THERE IS A DROP DOWNBUTTON ALWAYS VISIBLE - A CELL BESIDE THE CELL CONTAINIG DATA VALIDATION LIST.
no matter, i deleted row, recreated validation list, saved the activity etc... changed the location,
BUT THIS ARROW ..WHICH IS BOLD IN COLOR ...ALWAYS VISIBLE NEXT TO VALIDATION LIST.
I have check Activex control..etc, digged into VBA editor, searched every corner i know, googled.. etc, couldnot figure out what it is.
cut the cell containing drop down arrow wither on cell1 or cell2, it gets cut , and you can paste it some where
THE DROPDOWN ARROW IS VISIBLE ON LEFT END CORNER OF A CELL.
please see 2 images, its the button when hilighted next cell, and downlighted dropdown arrow when validation list cell activated.
1 important thing :
CANNOT USE ALT+DOWN ARROW BECAUSE OF THIS - where the validation list is present.
Validation list button is visible on top of the other drop downbutton when that cell selected ,
and when any other cell is slected, the DARK COLORED DROP DOWN BUTTON IS VISIBLE.
I moved the Validation list position , still that button appears beneath the validation list indicator.
if cell containing validationlist is selected, the additional button goes behing the validation listindicator - the drop dwon button ,
if another cellis selected , then the additional button is visible ( dark in color than the validation list button)
and hence
Alt+down arrow does not work, need to use poiner only
I have kept couple of sheets containing the issue of dowbledrop down ...,
also a sheet has validaiton list, but does not have doble drop down arrow issue.
Please checkon this, and your help will be most valuable lesson for me.
Request you all to help fix this issue.
I recently started using excel 2016, and this data / sheet is created by an employee who left.
There are many validation lists in workbook , when you select that cell , drop down arrow is visble , which is default/knowm THERE IS A DROP DOWNBUTTON ALWAYS VISIBLE - A CELL BESIDE THE CELL CONTAINIG DATA VALIDATION LIST.
no matter, i deleted row, recreated validation list, saved the activity etc... changed the location,
BUT THIS ARROW ..WHICH IS BOLD IN COLOR ...ALWAYS VISIBLE NEXT TO VALIDATION LIST.
I have check Activex control..etc, digged into VBA editor, searched every corner i know, googled.. etc, couldnot figure out what it is.
cut the cell containing drop down arrow wither on cell1 or cell2, it gets cut , and you can paste it some where
THE DROPDOWN ARROW IS VISIBLE ON LEFT END CORNER OF A CELL.
please see 2 images, its the button when hilighted next cell, and downlighted dropdown arrow when validation list cell activated.
1 important thing :
CANNOT USE ALT+DOWN ARROW BECAUSE OF THIS - where the validation list is present.
Validation list button is visible on top of the other drop downbutton when that cell selected ,
and when any other cell is slected, the DARK COLORED DROP DOWN BUTTON IS VISIBLE.
I moved the Validation list position , still that button appears beneath the validation list indicator.
if cell containing validationlist is selected, the additional button goes behing the validation listindicator - the drop dwon button ,
if another cellis selected , then the additional button is visible ( dark in color than the validation list button)
and hence
Alt+down arrow does not work, need to use poiner only
I have kept couple of sheets containing the issue of dowbledrop down ...,
also a sheet has validaiton list, but does not have doble drop down arrow issue.
Please checkon this, and your help will be most valuable lesson for me.
Request you all to help fix this issue.