How to add drop down box in excel spreadsheet

Drop-down lists can greatly facilitate data entry. Here's a look at how to use Excel's data validation feature to create handy lists within your worksheets. By Susan Harkins in Microsoft OfficeJune 11,5: You can create the same type of control for your users in an Excel sheet, but the process isn't intuitive. The option is in the Data Validation feature. Fortunately, once you know the feature exists, it's easy to implement. You need only two things: The following sheet shows a simple drop-down list in an Excel sheet.

Users click the drop-down arrow to display a list of items from A1: If a user tries to enter something that isn't in the list, Excel rejects the entry. To add this drop-down list to a sheet, do the following:.

You can add the drop-down list to multiple cells. Select the range of data input cells step 2 instead of a single cell.

Create a drop-down list - Office Support

It even works for noncontiguous cells. Hold down the Shift key while you click the appropriate cells. Susan Sales Harkins is an IT consultant, specializing in desktop solutions.

Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Cyberweapons are now in play: From US sabotage of a North Korean missile test to hacked emergency sirens in Dallas.

Elon Musk and the cult of Tesla: How a tech startup how to add drop down box in excel spreadsheet the auto industry to its core. The truth about MooCs and bootcamps: Their biggest benefit isn't creating more coders.

How to Create a Drop-Down List in Excel - BetterCloud Monitor

How Mark Shuttleworth became the first African in space and launched a software revolution. We deliver the top business tech news stories about the companies, the people, and the products revolutionizing the planet.

Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely swap spread box trade miss to stay current on the latest IT news, innovations, and tips. Defenses, response plans, and greatest concerns about cybersecurity in an IoT and mobile world. What's Tick stock market definition at TechRepublic The Macintosh we deserve: How Apple can win back loyalty from professionals Here's why it doesn't matter which coding language developers choose to learn 17 tips for protecting Windows computers and Macs from ransomware free PDF How to Come Up With Killer Business Ideas TechRepublic Academy.

For more Office and Windows tips, sign up for our Microsoft in the Enterprise newsletter.

LOG IN TO COMMENT. My Profile Log Out.

Free Newsletters, In your Inbox. Tech News You Can Use We deliver the top business tech news stories about the companies, the people, and the products revolutionizing the planet.

Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and tips. Latest From Tech Pro Research. Privacy Policy Cookies Ad Choice Terms of Use Mobile User Agreement. A ZDNet site Visit other CBS Interactive sites: Select Site CBS Cares CBS Films CBS Radio CBS.