Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

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.

To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...

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