 
|
To make it easier for people to enter data, you can create drop down lists on an Excel worksheet. Usually the source lists are stored in the same workbook as the drop downs. However, with named ranges, it is possible to use a list in a different workbook. In the screen shot shown below, [...] In Excel, you can use data validation to control (to some extent!) what users can enter in a cell. One option is to create a drop down list, so users can only select from a list of valid options. Data Validation Custom Criteria In some cases, a drop down list isn't practical, but [...] There's a popular sample file on my website, that lets you select multiple items from a data validation drop down list. Since the original article, I've posted updates: how to set up multiple selection edit multiple selection cells prevent duplicates in multiple selection columnAnd here is the latest update. Remove Previous Selections From Cell [...]In Excel, you can use data validation to create drop down lists on a worksheet. Usually, a simple list is all that's needed, to make it easier for people to enter the correct data. In this example, we use dependent drop down lists, where the cities shown in the second list depend on what country [...] Thanks to an email question from Leslie, I've done another variation on the Data Validation Multiple Selection sample. Leslie is scheduling training courses, and has a table with dates across the top, and course names down the side. One or more of the instructor names can be selected for each training session.
However, [...] Do you ever use the Excel CONVERT function? Do you avoid it, because you can't remember all the measurement unit codes? For example, the formula =CONVERT(10,"klt","gal") will convert 10 kilolitres to 2,641.7205 gallons – if you get those codes right. You might be able to remember lt and gal, but probably not many of the [...] I've done another update to the Data Validation Multiple Selection sample, thanks to a question from Pat, in a blog comment. He has 3 columns with different drop down lists, and wants to add new items to the applicable lists. I can get 3 separate columns to each allow multiple selects from their own lists [...] With Excel VBA programming, you can add a Combo Box to the worksheet, to show a data validation list. Usually a single column combo box is enough, like this list of weekdays.
In some cases, it's helpful to have a multi-column combo box. For example, instead of a single-column list with product [...] With data validation and some programming, you can select multiple items from a drop down list, and show the selections in a single cell. That technique is helpful in some situations, but it can make filtering difficult. With an AutoFilter turned on, only the combined results show in the filter options, not the individual [...] With dependent data validation, you can make one drop down list depend on the selection in another cell. For example, select Vegetables as a category in column B, and you'll see a drop down list of vegetables in column C. Problems With INDIRECT This technique uses the INDIRECT function, to return the range with [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
