【Original】【EXCEL Tips】Steps to set up a dropdown menu

2016-06-14View Original

Thread Content

Sometimes, when creating certain tables, it is necessary to set up drop-down menus with options of one’s own choice, such as ABCD or Male/Female. How to set it up? Follow the steps below. 1. Set the options in a particular column of cells; for example, enter the options A/B/C/D in cells A1 through A4 respectively. 2. Use the mouse to select the cell for which you want to create a drop-down menu, such as B1. 3. Then go to Data --> Data Validation --> Data Validation. 4. In the “Allow” field, select “Sequence”, and in the “Source” field, select the cells A1 through A4. 5. Done, settings are complete. There is a dropdown arrow at B1, allowing you to choose from the four options A, B, C, and D.

Submit a Project

**Looking for Chemical Technology, Equipment & Solutions?** No Registration Required Broader Platform Exposure | Global Chemical Service Provider Connections

Submit Request — Free Consultation

Disclaimer

This is an automated machine translation of the original thread. Some technical terms may have inaccuracies; the original text shall prevail. Click "View Original" at the top right to access the source page, which supports IP-based automatic real-time language translation. Please watch out for contact details and sales inducements to prevent fraud. All content and translations are for reference only, representing solely the poster's personal views. For enquiries, email service@hcbbs.com.

【Original】【EXCEL Tips】Steps to set up a dropdown menu

Thread Content

Related Threads in This Forum

← Previous

Next →

Submit a Project

Disclaimer

Quick Links