To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Create a drop-down list by selecting a range of cells The most common way to create a drop-down list in Excel with multiple selections is by using a range, which relies on using data from other cells.