How to force user to select data from a list in Excel?
In some cases, you want users to enter or select data from a list you specify in the sheet. Is there any way to solve this task? In fact, you can create a drop down list by Excel’s Data Validation utility to force users select data from such a list.
Force users to select data from a list
Force users to select data from a list
To force users to select data from a list, you can create a list of data you want users to select first, and then apply the Data Validation feature to create a drop down list from the data you have specified.
1. Create a list of data you need in column F.
2. Select a cell or a range you want to force users to select data from a list, and click Data > Data Validation. See screenshot:
3. In the Data Validation dialog, under Settings tab, choose List from Allow drop down list, and select the list you have created in step 1 to the Source textbox. See screenshot:
4. Click OK. Now the users only can select data from the list, if users type other data in the cells, there is a warning dialog popping out.
 |
 |
Related Article:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in