Download the featured file here https://www.bluepecantraining.com/wp...

In this Microsoft Excel video tutorial, I explain how to make your dropdown list buttons permanently visible. I explore two methods: the first uses the HYPERLINK function and the second uses a Combo Box (form control).

Timestamps
00:00 Introduction
00:16 Method 1: Use the HYPERLINK function and CHAR(128)
00:45 Use CHAR(128) for your dropdown
01:59 Use the HYPERLINK Function
03:11 Method 2: Use a Combo Box (form control)
04:34 Use INDEX to return the lookup value

#exceltutorial #exceltips #dropdownmenu