How to use Custom Data Validation in Excel

Подписаться 516 тыс.

Просмотров 25 тыс.

50% 1

How to use Custom Data Validation in Excel and set up validations like restricting entry to text, specific dates, numerical entries and more.
In this Excel tutorial you will find how to:
==============
1.Prevent the entry of future dates
2. Allow entries dependant on another cell
3. Allow only Text Entries
4. Only text entries with a specified length
5. Allow only upper case letters
6. Allow entry of weekdays only
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
*Link to get Microsoft Office 365:*
microsoft.msaf...
Disclosure: The above link is an affiliate link, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@Pakidesivlog 6 месяцев назад

Today() 2*b2 Istext() Isnumber() AND(istext(),(len()

@merine7420 5 лет назад

You're the best..thanks

@jacinthandrew 2 года назад

This is very useful, thank you , pls advise if there is a way to replace a one with a word ?

@SRT0202 5 лет назад

Appreciate your simplified explanation. Could you also please make simplified videos on pivot tables and power querry in excel. Thank you.

@PresentationProcess 5 лет назад

Thanks for the suggestion!

@mohamadraffi8260 5 лет назад

Very helpful content. Thank you Mr.Ram Gopal Ji

@PresentationProcess 5 лет назад

Good to know...

@georgeregoo 4 года назад

Excellent. But what about entry of a mix of character and Numeric (example a part No)

@pradyumnasatapathy321 3 года назад

This is so wonderful, and your explanation is great. Thank you

@abduljabbarkhan9107 4 года назад

Very well described. Learnt a lot.

@moodkn Год назад

So Nice... Thanks1

@alesachmad9486 5 лет назад

Good👍 Go on

@PresentationProcess 5 лет назад

Thanks! Appreciate your support!

@nature7751 3 года назад

very helpful

@rajashekarshekar5585 Год назад

Address

@abuisakhodadad4663 Год назад

great

@Nold47 5 лет назад

Thank you.

@rcnethreshgowda6347 3 года назад

Sir if there are any criteria's means we can use some if or sumifs function right then why we are nor using sumif or sum ifs for custom data validation ?