Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Fortunately, Excel provides built-in features that allow you to hide and password-protect your worksheets without requiring any programming skills. Password Protecting Excel Spreadsheet Data ...

What if you want to lock some cells on your worksheet but not the entire worksheet? In Microsoft Excel, you can lock a specific cell or cells from people trying to edit essential information in them.

Formulas are one of the most important components of an Excel sheet and as such, deserve–warrant–protection. You don’t want users accidentally changing formulas and impacting the purpose of ...

If you have sensitive data you'd like to keep from prying eyes in a Microsoft Excel file, the easiest way to protect it is with Excel's built-in password tools.

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.

Q. When I circulate my statistical Excel worksheet to users outside my company, I need to protect the underlying confidential formulas but also keep the worksheet easy for users to enter their data.

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

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 ...