Page 461 - Excel 2013 All-in-One For Dummies

Protecting the Spreadsheet 443
Don’t, however, deselect the Select Unlocked Cells check box as well as the Select Locked Cells check box, because doing this makes the cell pointer dis- appear from the worksheet, making the cell address in the Name Box on the Formula bar the sole way for you and your users to keep track of their posi- tion in the worksheet (which is, believe me, the quickest way to drive you and your users stark-raving mad).
Selecting what actions are allowed in a protected sheet
In addition to enabling users to select locked and unlocked cells in the work- sheet, you can enable the following actions in the protected worksheet by selecting their check boxes in the Allow All Users of This Worksheet To list box of the Protect Sheet dialog box:
✦ Format Cells: Enables the formatting of cells (with the exception of changing the locked and hidden status on the Protection tab of the Format Cells dialog box).
✦ Format Columns: Enables formatting so that users can modify the column widths and hide and unhide columns.
✦ Format Rows: Enables formatting so that users can modify the row heights and hide and unhide rows.
✦ Insert Columns: Enables the insertion of new columns in the worksheet.
✦ Insert Rows: Enables the insertion of new rows in the worksheet.
✦ Insert Hyperlinks: Enables the insertion of new hyperlinks to other doc- uments, both local and on the web. (See Book IV, Chapter 2, for details.)
✦ Delete Columns: Enables the deletion of columns in the worksheet.
✦ Delete Rows: Enables the deletion of rows in the worksheet.
✦ Sort: Enables the sorting of data in unlocked cells in the worksheet. (See Book VI, Chapter 1, for details.)
✦ Use AutoFilter: Enables the filtering of data in the worksheet. (See Book VI, Chapter 2, for more information.)
✦ Use PivotTable & PivotChart: Enables the manipulation of pivot tables and pivot charts in the worksheet. (For more about pivot tables, see Book VII, Chapter 2.)
✦ Edit Objects: Enables the editing of graphic objects, such as text boxes, embedded images, and the like, in the worksheet. (See Book V, Chapter 2, for details.)
✦ Edit Scenarios: Enables the editing of what-if scenarios, including modi- fying and deleting them. (For details of what-if scenarios, see Book VII, Chapter 1.)
Book IV Chapter 1
Protecting Workbooks and Worksheet Data