How To Lock Cells In Excel: A Complete Guide

Microsoft Excel is one of the most popular and easy-to-use software. It was created by Microsoft and it allows users to organize and format data in rows and columns format. In this article, we will see how we can lock cells in Excel and protect them with a password.

Lock All Cells

By default, it locks all the cells in a worksheet. But you have to protect your worksheet with a password. 

Protect Sheet

  • Right-click on the worksheet tab.
  • Click Protect Sheet.

protect

  • Enter a password of your choice.

protect 2

  • Check mark the actions you want to allow the user to perform on your worksheet
  • Click OK.

Business Analyst Master's Program

Gain expertise in Business analytics toolsExplore Program
Business Analyst Master's Program

Lock Specific Cells

You have to protect your sheet with a password after locking the cell. 

If you want to lock specific cells in Excel, first you have to unlock all the cells.

  • Select all cells.

step 1

FREE Course: Introduction to Data Analytics

Mastery to Data Analytics Basics is a Click Away!Start Learning
FREE Course: Introduction to Data Analytics

  • Right-click and then click format cells.
  • On the Protection tab, uncheck the locked checkbox and then click OK.

unlocked

  • Now, select the cells you want to lock.

specific cell

  • Right-click and then click format cells.
  • On the protection tab, check the locked checkbox and then click OK.

locked lock cells

Free Course: Introduction to MS Excel

Master the Fundamentals of MS ExcelEnroll Now
Free Course: Introduction to MS Excel

Lock Formula Cells

  • Select all cells.
  • Right-click and then click format cells.
  • On the Protection tab, uncheck the locked checkbox and then click OK.

unlocked

  • On the Home tab, click find and select.
  • Click Go To Special.

gotocspecial

  • Select Formulas and Click OK. Excel will select all the formulas in the sheet.

formula lock

  1. Go back to the Protection tab and checkmark the locked check box.

lock cells

Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Enroll now!

Conclusion

By locking cells in an Excel worksheet and protecting the worksheet, you can protect your work from unwanted tampering from other users.

Boost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course, which includes Power BI training

This Business Analytics certification course teaches you the basic concepts of data analysis and statistics to help data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from data in order to present your findings using executive-level dashboards.

If you have any questions, please feel free to ask them in our comments section, and our experts will promptly answer them for you. 

About the Author

Aryan GuptaAryan Gupta

Aryan is a tech enthusiast who likes to stay updated about trending technologies of today. He is passionate about all things technology, a keen researcher, and writes to inspire. Aside from technology, he is an active football player and a keen enthusiast of the game.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.