Excel like a finance pro.
← The libraryPractice · 2 questions →
Data shortcut
Open Data Validation
Alt, A, V, V on Windows, None on Mac.
CommonDifficulty 1100 · Proficient
When to use it
Opens Data Validation to restrict what can be entered: lists, numbers in a range, dates, or a custom formula.
The shape of it
- Windows
Alt, A, V, V
- Mac
None
Worked examples
Dropdown list
Select cells, Alt, A, V, V, Allow: List, Source: Yes,No → A dropdown with two choices
Controlled inputs.
Numeric range
Allow: Whole number between 1 and 100 → Other entries are rejected
Range checks.
No duplicates
Allow: Custom, =COUNTIF($A:$A,A2)=1 → Duplicates rejected
Formula rules.
Worth knowing
- Point the list Source at a Table column so it grows.
- Circle Invalid Data finds existing bad entries.
- Input and error messages guide users.
Where it goes wrong
- Pasting over validated cells bypasses validation.
- Lists with more than 255 characters typed directly fail; use a range.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.