How to add drop down menu in excel?

excel

Asked on September 28, 2021 in Computer.
Add Comment
  • 1 Answer(s)

    You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list.

    1. Select the cells that you want to contain the lists.
    2. On the ribbon, click DATA > Data Validation.
    3. In the dialog, set Allow to List.
    4. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

    Answered on September 28, 2021.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.