How to put options in a cell in excel

Posted: saga_po Date of post: 13.07.2017

Enter your email below to get exclusive access to our best articles and tips before everybody else.

By Lori Kaufman on January 24th, Drop-down lists make it easier and more efficient to enter data into your spreadsheets.

Simply click the arrow and select an option.

how to put options in a cell in excel

You can add drop-down lists to cells in Excel containing options such as Yes and No, Male and Female, or any other custom list of options.

Drop-down lists are created using the Data Validation feature. To begin, enter the list of age ranges into sequential cells down a column or across a row. We entered our age ranges into cells A9 through A13 on the same worksheet, as shown below.

You can also add your list of options to a different worksheet in the same workbook. To do this, select all the cells containing the drop-down list items and then enter a name for the cell range into the Name box above the grid. We named our cell range Age.

How to Use Excel's Insert Function Button - dummies

The Data Validation dialog box displays. This means that the user can select the cell and then deselect the cell without selecting an item.

If you want to require the user to select an option from the drop-down list, uncheck the Ignore blank check box. You can add a popup message that displays when the cell containing the drop-down list is selected.

If you added an input message, it displays below the cell. The down arrow button only displays when the cell is selected.

The options on the Data Validation dialog box are reset to their defaults. If there was an option selected when you removed the drop-down list, the cell is populated with the value of that option.

Creating a drop-down list in Excel 2013

Follow this process to add drop-down lists to other cells as needed. You can use the same list for multiple drop-down lists.

how to put options in a cell in excel

If you have many drop-down lists you need to add on a worksheet, you may want to put the lists of options on another worksheet in the same workbook. You can hide the worksheet containing your lists of options to prevent them from being changed.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.

How to add a drop-down list to an Excel cell - TechRepublic

Green, black, and oolong tea are all made from the same tea plant Camellia sinensis and are simply prepared and aged in a different fashion. Enter Your Email Here to Get Access for Free:.

Articles l l How to Add Bluetooth Headphones to Your HDTV. All the Cloud Storage Services That Offer Free Storage. RSS ALL ARTICLES FEATURES ONLY. Click Here to Join the Discussion.

How to add a drop-down list to an Excel cell - TechRepublic

How to Find and Remove Duplicate Files on Windows. How to Send and Receive Faxes Online Without a Fax Machine or Phone Line. How to Buy an SD Card: Speed Classes, Sizes, and Capacities Explained.

Everything You Need to Know. How to Benchmark Your Android Device: How to Fax a Document From Your Smartphone. GET ARTICLES BY EMAIL. Most of the pages on the internet include affiliate links, including some on this site.

inserted by FC2 system