You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

Sie können eine Dropdownliste mit gültigen Einträgen (auch Dropdownmenü oder Dropdownfeld genannt) in Excel einfügen, um so die Dateneingabe zu erleichtern oder die Eingabe auf bestimmte, …

Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows 11, Surface, and more.

When you use Excel for the web, we recommend that you use Microsoft Edge as your web browser. Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those …

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Work with stocks and geography data Turn your data into insights List of all Excel functions available VLOOKUP function IF function Create a drop-down list Combine text from two or more cells Freeze …

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). Watch …

For more information, see Use calculated columns in an Excel table. Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, …

Insert a combo box or a drop-down list In a combo box, users can select from a list of choices that you provide or they can type in their own information. In a drop-down list, users can only select from the …

To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values. You can apply conditional formatting to …