Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac

Restrict the cells users are allowed to change:

Lesson 7-11 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Restrict the cells users are allowed to change
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Expert Skills
Session: Session 7: What If Analysis and Security
Lesson: Lesson 7-11 Restrict the cells users are allowed to change Excel password protect cells. Thumbnail from Excel 2013 Expert Skills Lesson 7-11 Restrict the cells users are allowed to change.
Description:

This video lesson demonstrates how to prevent users from changing some cells on an Microsoft Excel worksheet while still being able to change others. This is done by locking and unlocking cells before protecting the worksheet. You'll see an example of how to create a worksheet with locked cells and learn about the different protection options that are available. You'll also learn how to use protection to keep your formulas secret, make forms more user friendly and make a workbook read-only.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email