How To Lock A Form in Excel - Creating Fillable Forms in Excel

HOW TO LOCK A FORM IN EXCEL // Learn to lock cells and protect your sheet when you create a fillable form in Excel. Unlike forms created in MS Word, there a several form features in Excel that are available for users without having to enforce protection on your document (for example, check-boxes and drop-down lists can be filled in by users on an unprotected Excel sheet). But, if you want to ensure the integrity of your form and make sure users don’t modify or change information, then there is an easy way to protect your document. Watch this video to find out how.

In this video we use an Employee Engagement Survey as an example form. This formatted template including the IF and VLOOKUP formulas is available for purchase and download at: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert
__________
RESOURCES & GEAR
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ Camera: https://amzn.to/39KvpQA
✦ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
✦ PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
__________
KEYWORDS: #MSExcel, #M365, How To Create Fillable Forms in Excel, How To Create Drop-Down List in Excel, How To Create a Form in Excel, Link Text to Drop-Down Using IF Formula, Link Text to Drop-Down Using VLOOKUP, Insert Checkboxes in Excel, How To Hide Worksheet Tabs in Excel, Employee Engagement Survey Template, How To Hide Spreadsheet in Excel, How To Hide Workbook in Excel, How to Unhide Very Hidden Tabs in Excel, Excel Fillable Forms, Excel Tutorial, Excel Lesson, Excel Tips and Tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR

Видео How To Lock A Form in Excel - Creating Fillable Forms in Excel канала Sharon Smith