Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Formatting the Worksheet > Protecting Worksheets from Changes

Protecting Worksheets from Changes

When you create a worksheet that contains sensitive data or data you don’t want changed by anyone other than yourself, you can protect the worksheet from unauthorized changes. From within the Protect Sheet dialog box, you can choose the actions you want to allow all users to be able to perform on the worksheet. The options selected by default will allow anyone to select a cell but will prevent them from deleting rows or columns, changing any formatting, or editing scenarios attached to the worksheet.

Protect a Worksheet

Click the Review tab.

Click Protect Sheet.

Select the protection options you want.

Click OK.

Tip

Specify a password in the Protect Sheet dialog box to restrict access to a workbook, worksheet, or part of a worksheet. After you’ve done this, only authorized users will be able to make changes.

Tip

You can protect chart sheets and other graphic objects in worksheets from unauthorized changes. Keep in mind, however, that if the source data for a chart sheet changes, your chart sheet will also change, even if you have the chart protected.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint