Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

http://www.excelcampus.com/tips/drop-list-arrow-always-visible/
The drop-down arrow for a validation list disappears when you select another cell. This technique shows you how to create a fake drop-down icon that will mimic the real arrow. Download the sample file at the link above.

Bill Jelen's solution in Mr Excel Podcast 1816 - http://youtu.be/gKxbDqoBWsw

Subscribe to my free email newsletter.
http://www.excelcampus.com/newsletter
00:00 Introduction
00:13 Drop-down List Arrow Always Visible for Data Validation
00:34 The Drop-down List Arrows Disappear
02:12 Create a Fake Drop-down Icon
03:35 Add a Hyperlink to the Fake Drop-down