Locking cells in a Microsoft Excel spreadsheet is a super useful thing to know how to do. It’s used to protect a certain segment or an entire worksheet from being modified by anyone other than ...

Open the spreadsheet you want to protect in Excel, click the "Review" tab and then click "Protect Sheet" in the Changes group to display the Protect Sheet dialog.

You can stop or prevent users from editing directly in cells in Excel. You have to lock and protect Cells in Excel by following these steps.

Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which is useful if you're sharing a spreadsheet with precise data.

At the file level, you can password protect an Excel workbook in two ways: You can determine who can get in and who can save changes.

With the Excel file open select File in the top-left corner of the screen, followed by Info. Select Protect Workbook, then choose Encrypt with Password.