Add Combo Box Drop Down List to Excel Worksheet

Use a combo box on an Excel worksheet to show a drop down list. Unlike a data validation drop down list, the combo box can be formatted.
For example:
-- change the font size
-- increase the number of visible rows in the list
-- use the AutoComplete feature to make data entry easier

This video shows you how to create an Excel combo box with a drop down list, and change its formatting.

Get the sample file and written steps on my Contextures site:
https://www.contextures.com/excelwork...

To name a range, such as ListA, select the cells B2:B13. Then, click in the Name Box, at the left of the Formula Box. Type a one-word name (ListA), then press the Enter key, to complete the name. Find details on naming ranges here:
https://www.contextures.com/xlNames01...

To add the Developer tab in Excel 2010:
-Right-click on the Ribbon, and click Customize Ribbon
-Add a check mark beside Developer, in the list at the right.
-Click OK, to close the Excel Options window.

To add the Developer tab in Excel 2007:
-Click the Microsoft Office Button, and then click Excel Options.
-Click the Popular category, and add a check mark to Show Developer tab in the Ribbon
-Click OK, to close the Excel Options window.

Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: https://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips #ExcelQuickTips