Data validation in Excel

Published: 17 May 2022
on channel: Ah Sing Excel TV

Prohibit/prevent users from giving invalid input by using Data Validation in Excel:
1. Type of validation criteria: any value, whole number, decimal et cetera
2. Dropdown list
3. Input message, when cell is selected, error alert and style
4. Circle Invalid Data and Clear Validation Circles
5. Transfer the data validation to other cells
6. Remove the data validation
7. Custom (capital letter) - FIND(UPPER(A1),A1)=1
8. Remove validation

Create restrictions for case entry (UPPER case, lower case, Proper case) 👉 • Restrictions on case entry (upper, lo...

Excel & VBA discussion public group 👉 / 486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗

#Excel #Lesson12

Watch video Data validation in Excel online without registration, duration hours minute second in high quality. This video was added by user Ah Sing Excel TV 17 May 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 45 once and liked it 1 people.

4,726