Excel Formatting Drop Down List. Ideally, you’ll have your list items in an excel table. Why should you put your data in a table?
Excel Drop Down List Syntax Byte
Click ok button to create your dropdown. In the source input box, enter your delimited list using commas as the delimiter between items. Web go to the settings tab and select list from the allow dropdown. Select new rule, and then select format only cells that contain. When your data is in a table, then. Why should you put your data in a table? Ideally, you’ll have your list items in an excel table.
Select new rule, and then select format only cells that contain. When your data is in a table, then. In the source input box, enter your delimited list using commas as the delimiter between items. Why should you put your data in a table? Web go to the settings tab and select list from the allow dropdown. Ideally, you’ll have your list items in an excel table. Click ok button to create your dropdown. Select new rule, and then select format only cells that contain.
