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

Learn how to improve your productivity by creating custom Excel shortcuts to improve efficiency when using spreadsheets in Microsoft's ...

To create one, name any unused worksheet Contents (by right-clicking on its tab and left-clicking on Rename .) If the tab is not in the leftmost position, use your left mouse button to drag the tab to ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Our visual guide helps you find the most popular commands on the Ribbon in Excel 2016 and 2019 for Windows, along with keyboard shortcuts for performing each action.