Microsoft Office Tutorials and References
In Depth Information
Protecting worksheets from changes
Protecting worksheets from changes
When you create a worksheet that contains sensitive data or
data that you don’t want anyone other than yourself to change,
you can protect the worksheet from unauthorized changes. In
the Protect Sheet dialog box, you can choose the actions that
you want all users to be able to perform on the worksheet. The
options selected by default allow anyone to select a cell but
prevent them from deleting rows or columns, changing any
formatting, or editing scenarios attached to the worksheet.
Protect a worksheet
1 Click the Review tab.
2 Click Protect Sheet.
3 Select the protection options that you want.
4 Click OK.
Search JabSto ::

Custom Search