Excel Drop Down Multiple Select or Remove
Loading...
Uploaded by contextures on Sep 4, 2011
http://www.contextures.com/excelfiles.html#DV0017
With Excel data validation you can create drop down lists on a worksheet. In this example, you can select multiple items from the drop down list, and the new items are automatically added to the existing selections in the cell.
If an item has been selected before, in the current cell, that item will be removed, if you select it again.
This video shows how the multiple select and remove features works. You can also see the Excel VBA code, and the steps that it goes through, when you make a selection in the drop down list.
You can download the sample Excel file for this technique, at the link shown at the start of this description.
- 6 likes, 0 dislikes
-
- 9:36
How to Search for Text Strings in Excelby DannyRocksExcels1,674 views
- 1:06
Using the Multiple Selection Drop-Downby ProjectInsightPMSW4,918 views
- 5:06
Create dependent drop down lists in Excel.aviby Computergaga6,067 views
- 2:15
Creating a Drop Down List in Excel 2010by aqueity10,669 views
- 7:01
Excel: Drop-Downs(Combo Box) and Conditional Formatting (Voice Tutorial)by iProRyan36,705 views
- 4:42
MultiSelectListBox.wmvby ExcelSupernerd3,993 views
- 4:42
MultiSelect ListBox 2by ExcelSupernerd5,111 views
- 4:04
MultiSelect ListBox... how do you read those values??by ExcelSupernerd7,540 views
- 4:08
How to Add or Edit Employee Records Online Payroll Serviceby PayrollExpress9,501 views
- 6:38
Use the INDIRECT() Function to Create a 2nd Pick From List in Excelby DannyRocksExcels8,961 views
- 2:44
Microsoft Excel - Multiple Choice Questionby ismaziz215,214 views
- 4:58
Different Drop Down Lists in Same Excel Cellby contextures29,109 views
- 3:29
Excel Drop Down List Automatically Changes Product Name to Codeby contextures7,242 views
- 3:47
Add Combo Box Drop Down List to Excel Worksheetby contextures42,397 views
- 3:13
How to add a multiple selection field to JomSocial video tutorialby ijoomla1,257 views
- 3:47
Excel Waterfall Chart Utilityby contextures3,725 views
- 0:40
Excel | How to have cells automatically formatted if they contain specific text?by OfficeToDo750 views
- 4:48
Excel VBA - Record and Run Excel Macroby contextures2,474 views
- 4:51
Pick Answers With Excel Option Boxesby contextures2,805 views
- 17:52
Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down Listby ExcelIsFun5,909 views
Nice tutorial but I've one question. How do I get the code from the SameCell sheet to work in protected sheet? The code works in nonprotected as shown.
luutarhaaja 1 month ago