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

If you would like to enable Shared Workbook option, here's a way to add it to Excel Quick Access Toolbar. It is hidden under Excel Options.

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...