Worksheet Protection

Tips, Tricks, and Answers

The following articles are available for the 'Worksheet Protection' topic. Click the article's title (shown in bold) to see the associated article.

Protecting Worksheet Names
Want to stop other people from changing the names of your worksheets? You can provide the desired safeguard by using the workbook protection features built into Excel.

Sorting in a Protected Worksheet
Protect a worksheet and you might find that you can't do some of the worksheet operations you would like to do. If you want to sort the data in a protected worksheet, you need to inform Excel that you specifically want to allow it.