Akehvie

Create drop down list but show different value in drop down list cell Create a range name for the cell values you want to use in the drop down list, in this example, I will enter the name dropdown in the Name Box, and then press Enter key, see screenshotThey are extremely simple to create and are a great way to make a spreadsheet easier to use In this article, I'll first show how to create an incell dropdown list using data validation, and then I'll show some examples that demonstrate awesome things you can do with drop downs Insert or delete a dropdown list To make data entry easier in Excel, or to limit entries to certain items that you define, you can create a dropdown list of valid entries that is compiled from cells elsewhere in the workbook When you create a dropdown list for a cell, it displays an arrow in that cell More On Data Validation Excel What is an excel drop down list