Part IV: Managing and Analyzing Data
FIGURE 34.3
Excel warns you if you attempt to change a locked cell.
The Locked attribute matters only when the worksheet is protected. On an unprotected worksheet, locked and
unlocked cells behave the same way.
Sheet protection options
The Protect Sheet dialog box (refer to Figure 34.1) has several options, which determine
what the user can do when the worksheet is protected:
Select Locked Cells If this is checked, the user can select locked cells using the mouse or
the keyboard. This setting is enabled by default.
Select Unlocked Cells If this is checked, the user can select unlocked cells using the
mouse or the keyboard. This setting is enabled by default.
Format Cells If this is checked, the user can apply formatting to locked cells.
Format Columns If this is checked, the user can hide or change the width of columns.
Format Rows If this is checked, the user can hide or change the height of rows.
Insert Columns If this is checked, the user can insert new columns.
Insert Rows If this is checked, the user can insert new rows.
Insert Hyperlinks If this is checked, the user can insert hyperlinks (even in locked
cells).
Delete Columns If this is checked, the user can delete columns.
Delete Rows If this is checked, the user can delete rows.
Sort If this is checked, the user can sort data in a range as long as the range doesn’t con-
tain locked cells.
Use AutoFilter If this is checked, the user can use existing autofiltering.
Use PivotTable & PivotChart If this is checked, the user can change the layout of
PivotTables or create new PivotTables. This setting also applies to PivotCharts.
Edit Objects If this is checked, the user can make changes to objects (such as shapes) and
charts, as well as insert or delete comments.
Edit Scenarios If this is checked, the user can use scenario management features.
