Log in
x
or
x
x
Register
x

or

Excel Tips: Security > Protect Cells

Encrypt or Decrypt Cells

How to encrypt/decrypt selected cells in Excel?

How to only hide part of cell value in Excel?

How to quickly hide cell contents in Excel?

How to quickly hide cell values in Excel?

Protect Cells by Criteria

How to lock or unlock cells based on values in another cell in Excel?

How to protect cells based on date in Excel?

How to protect or lock cell values based on background color?

Protect Nonblank Cells

How to lock and preotect nonempty cells in Excel?

How to lock or protect cells after data entry or input in Excel?

Protect Cell Formatting

How to lock cell width and height from resizing in Excel?

How to lock column width in pivot table?

How to protect cell formatting but only allow data entry in Excel?

Protect Formulas

How to lock and protect formulas in Excel?

How to not show/hide formulas from formula bar in Excel?

Others

How to limit access to a range of cells in Excel?

How to lock and protect selected cells in Excel?

How to lock and unlock specified cells with a checkbox in Excel?

How to lock specified cells without protecting the whole worksheet in Excel?

How to lock/unlock cells in a protected worksheet?

How to make cell as read only in Excel?

How to make specific cells unselectable in Excel?

How to only allow changes to certain cells in Excel?

How to prevent cell contents from printing in Excel?

How to prevent data entry into specific cells of a worksheet in Excel?

How to prevent page break across merged cells in Excel?

How to prevent specific cell contents from being deleted in Excel?

How to protect / lock all but certain cells in Excel worksheet?

How to protect / lock hidden columns in Excel?

How to protect different ranges with different passwords in Excel?