Creating a form in Excel involves selecting and placing form controls on your worksheet. To start, go to the Developer tab and click on Insert to view the available form controls.

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list.

Why you’d want to add the Developer tab The Developers tab gives you quick access to many of the advanced features available in Office applications.

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.