Microsoft Excel - Allow Edit Ranges

Learn a more user-friendly way to apply sheet protection, as well as how to protect cell ranges based on a user's login credentials (no passwords required).
00:19 Commonly Used Cell Protection Strategy
01:05 The Problem with Standard Protection
01:16 New Way to Implement Cell Protection
02:39 Updating Password Information
02:57 Username Authentication
04:11 Dealing with Conflicting Permissions
05:46 Delete Protection Ranges