Open Microsoft Excel and select the sheet you want to lock. Make the required changes. When you are ready to share, click File at the top. Select Info from the sidebar. Select Protect Workbook.

Key Takeaways : Excel spreadsheets can be protected by Edit Ranges, Sheet Protection, Workbook Protection, File Modify Password, VBA Project Password, and File Open Password.

How to Tell If a Worksheet Is Protected in Microsoft Excel 2003. Protecting a worksheet in Excel 2003 prevents others users from editing it. For example, if you have tracked and charted your ...

Using Microsoft Excel 2007, you can protect worksheets in order to keep other users from making changes. Unfortunately, this protection applies to everything on the worksheet, including groups.