Search notes:
Excel: Review -> Protect -> Protect Sheet
In some versions of Excel, this Menu is
Review -> Changes -> Protect Sheet
.
Review -> Protect -> Protect Sheet
allows a user to protect certain aspects of a
worksheet
:
Select
locked cells
Select
unlocked cells
Format cells
Format columns and/or rows
Insert columns and/or rows
Delete hyperlinks
Delete columns/rows
Sort
Use AutoFilter
Use
PivotTable
& PivotChart
Edit objects
Edit scenarios
If a sheet is protected, some entries in the «context menu» are grayed depending on the selected options.
See also
The
Protection tab
of the
Format Cells popup
.
The methods
protect
and
unprotect
of the
worksheet
object
.
The menu
Home -> Cells -> Format -> Protection
The functionality that is offered in this menu can also be reached via
File -> Info -> Protect Workbook
-> Protect Current Sheet.
Index