Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

In this tutorial, we will explain how to create a bulleted list using the CHAR function in Microsoft Excel. Bullets are black circle points but can also be any symbol.

Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet). Select a cell — I selected B2. Click the Data tab.