Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

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

Inserting Drop-Down Lists with Data Validation Once you have created named ranges for your lists, the next step is to insert the drop-down lists using Excel’s data validation feature.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.