⬇️How to Keep Drop Down Buttons Always Visible in Excel
Download the featured file here https://www.bluepecantraining.com/wp-...
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
