|  

» Protecting Sheets / Cells in Microsoft Excel

You can protect the content of cells from being changed and/or hide the formulas of cells from being viewed.

Conditions for protecting cells

  • The cell must be locked (in the Format Cells dialog box, Protection tab).
  • The sheet must be protected.
Conditions for hiding text/formula in the Formula bar
  • The cell must be hidden (in the Format Cells dialog box, Protection tab).
  • The sheet must be protected.



Rate This Tip
12 34 5
Rating: 2.70     Views: 34058
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments