To create a drop-down list, select cell where you want it to be (in this case, cell I2), and in the Data tab on the ribbon, click "Data Validation" in the drop-down option with the same name.

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

Simplify Excel navigation with a custom sidebar! Learn 3 easy methods to create a streamlined, professional interface for your workbooks.

This guide shows how to create progress bars in Excel using Bar Charts and Conditional Formatting on a Windows 11/10 PC. Take a look.

Learn how to create a Timeline in Excel using a Column Chart, SmartArt, or an Excel Template. Timelines are essential for planning and communicating time-based data.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.