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.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

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

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

If a user inadvertently changes the formulas in your Excel workbooks, all your hard work could go out the window. This ebook explains how to protect and hide those formulas so they remain safe and ...

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.

Protecting a worksheet in Excel 2003 prevents others users from editing it. For example, if you have tracked and charted your business's sales on a sheet, you will want co-workers to access the ...