Chapter 1: Drop-down lists (Data Validation)
Exercise 4: Remove a drop-down list
Task
Remove the drop-down from the Rep column (B2:B6). Keep the values as they are.
Moves 0 (target 1)5 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Project | Rep | Status | |
| 2 | Acme quote | Smith | ||
| 3 | Birch invoice | Johnson | ||
| 4 | Cobalt contract | Williams | ||
| 5 | Delta order | Brown | ||
| 6 | Ember delivery | Jones | ||
| 7 | ||||
| 8 |
Remove the drop-down from the Rep column (B2:B6). Keep the values as they are.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B6
- Data → "Data Validation" (Alt → A → V → V)
- Click "Clear All" at the bottom left, then OK
Key takeaway
Removing data validation does not delete values already in the cells.
See How to create a drop-down list in Excel for details.