The Excel VBA/Macro Course [On Sale!]: https://www.teachexcel.com/vbacourse...

Download the File: https://www.teachexcel.com/exceltuto...

How to make a data validation dropdown list arrow that is always visible in Excel.

This allows your users to visually see that there is an incell list without having to first click that cell.

The method used here does not require any Macros, VBA, Shapes, or Objects – it is 100% formatting combined with a simple formula that you can copy/paste from the downloadable file for this tutorial.

Resources:
DropDown List in Excel (Microsoft): https://support.microsoft.com/enus/o...
TeachExcel Online Courses: https://www.teachexcel.com/premiumco...

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel