Use This Trick To Restrict Data Entry In Excel
Sometimes users type something in Excel that isn't correct. Follow the simple steps in this Microsoft Excel tutorial and learn how to restrict what data can be entered onto a spreadsheet which will work for most versions of Excel in this Excel tutorial for beginners.
Here is the formula used in the video:
=ISNUMBER(SEARCH("Yes", B2))+ISNUMBER(SEARCH("No", B2))
=ISNUMBER(SEARCH("Yes", A1:C10))+ISNUMBER(SEARCH("No", A1:C10))
If you are interested in more information about Microsoft then I highly recommend the channel @Microsoft
#microsoftexceltutorial #exceltutorial #usemybox
Remember to subscribe to Usemybox for computer how to videos in Excel, Word, Powerpoint, Windows, internet browsers and more.
Subscribe for More IT & Software How To Videos:
https://youtube.com/usemybox?sub_conf...
Смотрите видео Use This Trick To Restrict Data Entry In Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь usemybox 22 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 599 раз и оно понравилось 3 людям.