Skip to main content

Excel Tips: Security > Protect Cells

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?

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?