Download the featured file here https://www.bluepecantraining.com/wp-content/uploads/2023/12/Drop-down-always-visible.xlsx

In this Microsoft Excel video tutorial, I explain how to make your drop-down 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 drop-down
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