⬇️How to Keep Drop Down Buttons Always Visible in Excel

Описание к видео ⬇️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

Комментарии

Информация по комментариям в разработке