Creating Forms with Dropdown options using Excel

Felicia B 0 Reputation points
2024-04-25T15:13:49.79+00:00

I am creating a request form using Excel. I want to be able to allows users to select one of the options from the drop-down or fill in the necessary information.

  • Can I create a drop down that allows users to select from the list or fill in relevant information? Is there another method I could try?

Thanks,

Felicia B

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Korchok 4,936 Reputation points
    2024-04-25T15:44:38.73+00:00

    Here is Microsoft's page on creating a dropdown on a worksheet:

    https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b

    Usually, if you want to give users the option of entering information, you add an Other choice to the dropdown. Then you include a separate field for users to enter other information.