How to always show arrow of data validation list in Excel?
In general, the arrow in data validation list only show while you click at the cell of drop down list, if not, the arrow is hide as below screenshot shown. Sometimes, you may forget the location of the drop down list without its arrow shown. In this article, I introduce a trick to always show the arrow of data validation list for you to quickly find and locate the drop down list in Excel.
You maybe interested in this:
Batch Insert Check Box/Option Button
|Do you still insert check boxes or option buttons one by one? With Kutools for Excel's Batch Insert Check Box and Batch Insert Option Button utilites, you can insert check boxes and option buttons in a range with one click.|
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
There is no directly way to show data validation list arrow all the time, here I introduce a roundabout way for you.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
1. Select the first cell right to the data validation list, here is D1, and click Insert > Symbol. See screenshot:
2. In the Symbol dialog, under Symbols tab, select Wingdings 3 from the Font drop down list, and select down arrow from the list section. See screenshot:
3. Click Insert and close the dialog, then the down array has been inserted in D1. Then resize D1 as same size as the arrow of data validation list. See screenshot:
4. Then go to format the symbol to a real arrow button. Select D1, and click Home > Fill color to select Gray 25/% Background 2 and then select White, Bacground1, Darker 50% from Font color list. See screenshot:
Now even when no clicking at the Data Validation list, the arrow is always showing.