Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Locking & Unlocking Cells to Protect Data in Excel


This excel tutorial shows you how to lock and ulock cells in excel. This is a feature that allows you to select whether or not a cell can be edited or changed while a worksheet is protected. This allows you to have a fully protected worksheet while still having some cells available to edit.
   Topics Covered
Lock & Unlock Cells
Editing cells while the worksheet is protected
It is assumed you already know how to protect a worksheet
   Difficulty:         Easy
   Video:               Yes



Got a Question? Ask it Here in the Forum.