The Excel VBA/Macro Course [On Sale!]: https://www.teachexcel.com/vba-course...
Download the File: https://www.teachexcel.com/excel-tuto...
How to make a data validation drop-down list arrow that is always visible in Excel.
This allows your users to visually see that there is an in-cell 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:
Drop-Down List in Excel (Microsoft): https://support.microsoft.com/en-us/o...
TeachExcel Online Courses: https://www.teachexcel.com/premium-co...
#msexcel #tutorial #exceltips #freetutorial #exceltips #excel