Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Sharing Your Work with the Outside World
Figure 19-8: Specify a password that removes worksheet protection.
Protect sheet elements and actions
Take a moment to familiarize yourself with the some of the other actions you can limit when
protecting a worksheet (refer to Figure 19-8). They are as follows:
Select Locked Cells: Allows or prevents the selection of locked cells.
Select Unlocked Cells: Allows or prevents the selection of unlocked cells.
Format Cells: Allows or prevents the formatting of cells.
Format Columns: Allows or prevents the use of column formatting commands, including
changing column width or hiding columns.
Format Rows: Allows or prevents the use of row formatting commands, including changing
row height or hiding rows.
Insert Columns: Allows or prevents the inserting of columns.
Insert Rows: Allows or prevents the inserting of rows.
Insert Hyperlinks: Allows or prevents the inserting of hyperlinks.
Delete Columns: Allows or prevents the deleting of columns. Note that if Delete Columns is
protected and Insert Columns is not protected, you can technically insert columns you can’t
delete.
Delete Rows: Allows or prevents the deleting of rows. Note that if Delete Rows is protected
and Insert Rows is not protected, you can technically insert columns you can’t delete.
Sort: Allows or prevents the use of Sort commands. Note that this doesn’t apply to locked
ranges. Users can’t sort ranges that contain locked cells on a protected worksheet, regardless
of this setting.
Use AutoFilter: Allows or prevents use of Excel’s AutoFilter functionality. Users can’t create or
remove AutoFiltered ranges on a protected worksheet, regardless of this setting.
Use PivotTable Reports: Allows or prevents the modifying, refreshing, or formatting pivot
tables found on the protected sheet.
Edit Objects: Allows or prevents the formatting and altering of shapes, charts, text boxes,
controls, or other graphics objects.
Edit Scenarios: Allows or prevents the viewing of scenarios.
Search JabSto ::




Custom Search