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

This trick works across the workbook. So, if you are on a different sheet and select a bookmarked cell from the drop-down menu, Excel jumps to that cell on another sheet.

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

In many versions of Excel, you can use a Microsoft date picker control to create an Excel date drop-down in a cell. Unfortunately, this won't work in 64-bit versions of the popular spreadsheet ...