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

Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer.

Microsoft Excel allows you to assign names to any cell range using its "Define Name" utility, assessable via the right-click menu.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.