Tips, Tricks, and Answers

The following articles are available. 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.