Microsoft Excel: Protecting Sheets & Workbooks

Wishlist Share

About Course

Learn the three levels of protection in Excel: locking cells on a worksheet, protecting workbook structure, and encrypting a file with a password. You will see what each one does and does not do, so you can stop accidental changes and choose proper security for confidential data.

This course is general training. Menu names and features can differ between Excel for Microsoft 365, Excel 2021/2024, older versions, Mac and Excel for the web, so check Microsoft Support for your version. Tutwoo is independent and not affiliated with Microsoft.

What Will You Learn?

  • Lock formula cells while leaving input cells editable Hide formulas and protect workbook structure Encrypt a workbook so it needs a password to open Understand the limits of protection and when to use access controls instead

Course Content

Course Lessons

  • Three levels of protection
  • Locking cells and protecting a sheet
  • Workbook structure and Allow Edit Ranges
  • Encrypting files and the limits of protection

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕