Use This Trick To Restrict Data Entry In Excel

Published: 22 June 2024
on channel: usemybox
599
3

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...


Watch video Use This Trick To Restrict Data Entry In Excel online without registration, duration hours minute second in high quality. This video was added by user usemybox 22 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 599 once and liked it 3 people.